drop down menus

  • Thread starter Thread starter lost in query_land
  • Start date Start date
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
 
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
 
Back
Top