drop down list in query

[Sasha]

hi

i hv to write a query which filters data on two criteria.
since criterion 1 contains 139 distinct names and
criterion 2 contains 463 distinct names, i would like to
provide a drop down list from which the user selects the
criteria. how do i go about it?

thnx

sasha

 

[Howard Brody]

Put 2 ComboBoxes on a form, one for each of the criteria
items, and a CommandButton to run the query. In the query
itself, reference the two ComboBoxes in the criteria lines
for the appropriate fields.

Hope this helps!

Howard Brody

 

[Sasha]

Hi Howard...

thnx..it works!!

Sasha

-----Original Message-----
Put 2 ComboBoxes on a form, one for each of the criteria
items, and a CommandButton to run the query. In the query
itself, reference the two ComboBoxes in the criteria lines
for the appropriate fields.

Hope this helps!

Howard Brody


.