Query Filter Based on Drop Down Box

[Locust2000]

I have a query and the result chart report I want created. Currently I have it pop up a dialog box where I type in the filter criteria e.g. "MTE" or "DAR" (our customer's codes). These are stored in a seperate table(which I can make a drop-down box show and scroll through).

What is the best way to use the selected record from the drop down box be used as the filter?

Have to use Access97 by the way.

 

[johanN]

I did this using a listbox. In the where of the query I refered to the listbox as follows

[forms]![formname]![listboxname]

Hope this helps