Drop Down Lists

[Guest]

I am using Access 2003
I created a db with a main menu form in which the users can pick the forms
and/or reports they want to see. Currently, when you click on a buttom, you
are asked to enter a name or a beg/end dates, depending what you are opening.
Now my boss wants a drop down list to appear, so that he only has to click
on a name or a month. I currently have a field called "ownername" that is a
drop down list.
How do I get the query to offer a drop down list? How can I get this to
populate with the drop down list, for the user to pick from?

I would appreciate any help you can give me - aurora

 

[Guest]

Create a form that has a combo (one or more) on it, and create a reference to
this combo from the query, and from this form open the resault form or query.

Check this link on "Filtering the results of a Microsoft Access query using
a Drop-Down combo box"

http://www.databasedev.co.uk/query_filter.html