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

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

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Form with dependent combo boxes (beginner)

Form with dependent combo boxes (beginner) in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: dependent   (beginner)   Form dependent   Form dependent combo   boxes (beginner)  
mrs179
-- UNK

Hello-

Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one:

I am entering data related to employee attendance at professional development sessions.  There are six categories of sessions, and each category contains about 20-40 independent sessions.

For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions. 

The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second?

Thanks in advance.

 Posted 12 years ago (Thread Starter)
Comment Quote
About mrs179 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
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 #13046, 1 replies
Thread Started 9/26/2008 2:01:35 PM
View Counter=4325
Last Reply Posted 9/20/2010 9:57:48 AM)
Location=-- UNK 
Joined=12 years ago   MB Posts=1  
Most Recent Post
dmichael
Tupelo, MS

You asked:

For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions. 

The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second?

I suggest:

The first combo box has options listed in a query or table showing the categories. 

The second combo has options listed in a query.  Within that query, you limit the results based on the selection chosen in the first combo box.

In the OnChange property of the first combo box, you issue a requery to the second combo box to update the list of options.

Hope this helps, even though I now see my answer was pretty late in arriving.

8^D

 Posted 10 years ago
Comment Quote
About dmichael -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14297 (Level 1.1)  Reply to 13046
Thread Started 9/20/2010 9:52:17 AM
Location=Tupelo, MS  
Joined=19 years ago   MB Posts=18  

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 = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #13046 Counter
4325
Since 9/26/2008

Follow PrestwoodBoards on: 


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