Search with a drop down menu

[Guest]

its probably very simple, but here goes:

I have a table VAN, a query VANQ and a form VANF. When the user starts the
database, query VANQ is automatically run, the rresults of which address
table VAN and the relevant data from the table (that where the category is
the same as the user's input) is displayed in VANF.

This all works. However, most of the category names (e.g. Rotary hammers
and Breakers) are farily long winded, and it would be easy if the (20 or so)
different categories could be displayed on the Enter Parameter query window
through a drop down menu/lookup list.

HOW would i do this?

Many thanks

 

[Duane Hookom]

Use a combo box on a form or your form to allow the user to make the
selection. There are some examples on Martin Green's web site
http://www.fontstuff.com/access/index.htm