open query by list box?

romanticode

Registered User.
Local time
Today, 17:01
Joined
Oct 26, 2007
Messages
39
i have several query and want to open it by combo box & button.

if user select "AA" on combo box an then pres a button, query "11" will be opened.
if user select "AB" on combo box an then pres a button, query "12" will be opened.
etc

how can i make that form?

thanks
 
so in the onClick event of the button, you would put
Code:
if me.listboxname ="AA" then
docmd.runquery "11"
else if me.listboxname="AB" Then
docmd.runquery "12"
else ....
 
how to make filter using listbox item based on user selected item (multiselect). and if nothing selected, all record will be showed.

thanks
 

Users who are viewing this thread

Back
Top Bottom