>>>Time for dumb question of the week.
>
>>There are many ways to do this job. I think the normal way is following:
>.............
>
>I tried using cursors and requery. The problem with the cursor is I can't get the select statement to recognize the first combo's value for the where close. eg Select SectionName, SectionCode from Sections into cursor vSection where Dept_code = cmbDept.Value
>
>I get an error that the cmbDept doesn't exist. I've prefaced with the form name but still no dice. I'll keep plugging.
>
>Thanks for your help,
>Larry
>US EPA

First of all keep clear syntax like:
cDept=thisform.cmbDept.value
Select .... where Dept_code = cmbDept.Value
Secondly, check BoundColumn property of the first combobox. If you select more than 1 field, this property indicates what field goes to Value. Just to test it nicely put Wait Window this.value into Valid snippet and check what you get. Your problem will be resolved.