A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Something like a three-tiered JavaScript menu...



 
 
Thread Tools Display Modes
  #1  
Old February 14th, 2007, 12:41 PM posted to microsoft.public.access.queries
cprav
external usenet poster
 
Posts: 39
Default Something like a three-tiered JavaScript menu...

I have a database in which someone has entered various organizations.
Included in the fields a
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!
  #2  
Old February 14th, 2007, 02:05 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 2,364
Default Something like a three-tiered JavaScript menu...

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/ac...730581033.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.