Something like a three-tiered JavaScript menu...

[cprav]

I have a database in which someone has entered various organizations.
Included in the fields are:

County
Town
Organization Name

I want to create a user-friendly query to filter these records. This is
what I'm thinking of:

1. User opens a form and sees one combo box where they can choose from a
list of counties that had been entered in the database.
2. A second combo box pops up. The user chooses "Show all" and the query
is run (automatically or after clicking a button whichever is easier for me
to do!) or chooses from a list of towns that were entered into the database.
3. A third combo box pops up the same as #2, but the user chooses an
organization (or show all). The query is then run.

OR

all three combo boxes can be visable from the start if option one is too
difficult for me.

I do not know much/if any programming so if this is required, please be
specific.

Thanks a lot, this place is great!

 

[John Spencer]

This link describes two methods of doing it:

http://www.mvps.org/access/forms/frm0028.htm

Post back if you need help.

Additional References:
http://www.comeandread.com/access/tip016.htm

Also Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx