1 query to be used in several forms, but need to have a changeable criteria
Windows 7 64bit 
Access 2010 32bit
Hey guys,
I have a query built that goes through our entire employee table. It lists first name, last name, title, and store number.
In this database I have several forms that have a combo box on them where the user selects a salesperson. Currently all stores salespeople are listed. I want to add a "store" combo box to each one of these forms to narrow down the list. (we have 500 salespeople). I know I could obviously make a different query for each form and bring in that combo box. I am just curious if there is a way to do it without having to have multiple slight variations of the same query.
Follow what I am saying?
Reply With Quote
