form with drop down query

S

seth

I am trying to build a form with a list box that will show the emp range
available in a table and the user can choose any one drop down range ex:1-4
or 5-9 and the run button will pull all the recoirds that have that
range.(records are marked with this range column in the table).please help
 
S

scubadiver

If you are looking for a way of selecting multiple choices I can't help ...

Make the combo box unbound, go to the "other" tab on the properties and give
the combo a name.

Create a query with your records. In the appropriate field, insert the
filter in the criteria:

[form]![formname]![comboname]

To check that it works, choose an option from the combo box and then try
opening the query. You should see the appropriate records listed.

In the form, create a button that will open the query, use the afterupdate
event in the combo to refresh a subform that will list the records or do
whatever you want to do :)
 
Top