Query by form

[waylander32]

Hope someone can help

I've done a query by form ie the user can select their own criteia via drop downs.

What I need to do is, if there is more then one crtieria , the second drop down needs to only show data from results of the first criteria

at the minute the query is run when the user press a button.

Can someone help???


Waylander

 

[Guus2005]

you can base the result of the second dropdown to the result of the first dropdown. Dropdown2:

select * from table1 where id = [form1].[dropdown1]

Search the site for more examples.

HTH