Is it possible to have a query with a criteria that you can select from a list. For example, when you open a query there's a prompt asking for information and instead of typing the information, is it possible to have a drop down menu????
Make a form with the fields you want as a drop down box.
Ex: make a form and put a combo box named PRODUCT and put your products in the combo. Open your QUERY in design mode and go to the criteria area and type Like [Forms]![FORMNAMEGOESHERE]![PRODUCT]
Close and save the query. When you run the query, it will ook t the form and that field. You can do this for multiple fields as well. To pull ALL values, just enter a * (star symbol, located on the 8 key).