Drop Down Lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aurora - 08 Mar 2007 19:19 GMT

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

Reply to this Message

Ofer Cohen - 08 Mar 2007 19:49 GMT

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

Signature

Good Luck
BS"D

> I am using Access 2003
> I created a db with a main menu form in which the users can pick the forms
[quoted text clipped - 7 lines]
>
> I would appreciate any help you can give me - aurora

Reply to this Message