Query by form

waylander32

Registered User.
Local time
Today, 07:02
Joined
Oct 20, 2010
Messages
20
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
 
you can base the result of the second dropdown to the result of the first dropdown. Dropdown2:
Code:
select * from table1 where id = [form1].[dropdown1]

Search the site for more examples.

HTH:D
 

Users who are viewing this thread

Back
Top Bottom