>>>>>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 =cDept && SORRY, MY FAULT
>>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.

and don't forget that combo boxes can also return the number of the item you have selected...