Query Criteria with a drop down box or all 1

[Element74]

I am a new user to Access running Access 2000.

Currently I have the following criteria for a query.

Like [Enter Vendor or Hit Enter for All] & "*"

I would like to have a drop down box for all the vendors instead of having the user to type the name.

How can I do this and still let them display all vendors?

I have a table with the vendor names already listed which a data entry form uses as a drop down box to eliminate typos and to keep all the vendor names the same.

Thanks in advance

 

[FancyPrairie]

I generally create a Report Criteria Form from which the user can select the criteria they want included on the report. In your case, the form might contain, at least, the list box of vendors. This FAQ faq181-5497 contains a function that will build the Where clause for you. It works on single and multi-select listboxes, combo boxes, text boxes, ranges, option groups, and check boxes.

 

[Element74]

I checked the FAQ and that is quite complex for my level of Access knowledge, is there anything that is relatively simple?

 

[dhookom]

FancyPrairie's solution is great and it might be good to try to understand it at some point. To get a less flexible yet very functional example, check this

http://www.fontstuff.com/access/acctut08.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]