Runnig Queries from List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Hi PC,

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