Open Query From Combo Box In Form
Posted on 2004-09-04
i have querys named:
mar 01.... ranging all the way to dec 04
I have created a table called "Month (Stats)", with one field called "Month".
In this field i have all the same names as my querys jan 01, feb 02, mar 03, apr 04 etc....
I have also created a form with a combo box that lists all the options from this table.
Is it possible to run the correct query that corrosponds with the same month from this combo box.
also is it possible to have a command button next to this combo box that will open the selected query.
if this isnt clear enough im, sorry, but you guys will probably know what im on about.