Runnig Queries from List Box

S

Sky Warren

Hello to all,

I would like to run 3 different queries from a list or drop down box.
However, I don't know how to code them to achieve this. What I would like is
for a user to be able to run a query for either "Calendars", "Cards" or
"Letters".

Is there a way to code this into a List or Combo box?

Sky Warren
 
P

PC Datasheet

Assuming your list or drop down box has the value "Calendars", "Cards" or
"Letters", put the following code in the AfterUpdate event of your list or
drop down box:
DoCmd.OpenQuery NameOfYourListOrDropDownBox
 
S

Sky Warren

Hi PC,

Thank you very much for your reply and your cool solution. The List Box
works great without error. You ROCK!!!
 
Top