drop down menus

L

lost in query_land

I have created a query, from a table, that prompts user to
enter the year for which they require, e.g., 2001. That
piece works well. However, the question was raised as to
whether or not, instead of typing the year, a drop down
menu could be created so the users could select the year
rather than type it. Is this possible and if so, how?

thanks in advance,

Ed
 
E

Evan McCutchen

Ed ,

You may want to create a form based on that query and insert a "go" button
and a combo box on that form with a value list filled with the years. Then
when the user clicks the "go" button, the query will run, with the value
specified in the combo box. Its all relatively simple to do. If you need
something to reference, I highly reccomend:
http://www.fontstuff.com/access/acctut08.htm.

Best of Luck!
Evan McCutchen
Radiology OneSource IT
Evan AT nospamDOTradiologyonesourceDOTcom
 
Top