I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Dependent Choices in Combo Boxes

Dependent Choices in Combo Boxes in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: Dependent   Choices   Dependent Choices   Dependent Choices Combo  
Bob D
 (Inactive)
San Diego
My efforts to find a solution to my problem in my books have failed, so I am asking for help.

I would like to set up an Access db such that the choices which appear in a combo box are dependent on the choice made in a previous combo box.

For instance, if "Major" and "Minor" are the only two choices in the first combobx, the one you choose affects the choices you will be given in a second combobx.

Any help will be greatly appreciated!

Thanks very much,

-Bob in California
 Posted 18 years ago (Thread Starter)
Comment Quote
About Bob D -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #7904, 1 replies
Thread Started 10/11/2002 5:24:00 PM
View Counter=1853
Last Reply Posted 10/14/2002 10:30:00 PM)
Location=San Diego  
Joined=19 years ago   MB Posts=8  
Most Recent Post
dynamictiger
Perth, Western Australia
To create this type of combobox set up is a bit tricky.

In the second combo box edit your row source property, and include the value from Combobox 1 as one of your query parameters.

I like the onchange event, others may disagree but, in the onchange event of the first combo box write some code like:

Me.combobox2.requery

This will force the 2nd combo box to requery itself every time the first combo box is changed.

HTH
Athlon XP 1600
Windows XP
Office XP

Perth the most isolated capital in the world
 Posted 18 years ago
Comment Quote
About dynamictiger -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #7926 (Level 1.1)  Reply to 7904
Thread Started 10/14/2002 10:30:00 PM
View Counter=2
Location=Perth, Western Australia  
Joined=18 years ago   MB Posts=62  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1135A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #7904 Counter
1853
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech