drop down list in query

  • Thread starter Thread starter Sasha
  • Start date Start date
S

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
 
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
 
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


.
Click to expand...
 
Back
Top