Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Combo Box to Control a Subform
Horace Conti 
    
4 years ago
I would like to have a Combo Box list Customers, then pick a Customer from a list of Customers shown in the Combo Box, then bring up that single record in a SUB-FORM.  (I'm trying to use a SUB-FORM to search records and then control a SUB-FORM using that COMBO BOX.)  I've watched Richards "INVOICING" video that is very similar, but in this video the navigation buttons are used to access SUB-FORM records, not the combo box. Thank you
Scott Axton  @Reply  
        
4 years ago
Horace -
I'm kind of at a loss for words here.  Quite honestly your description makes no sense to me.  Perhaps if you post a picture of what you have - notating what you want it to do it would help.
I feel that either you don't have a firm grasp on terminology or that you don't understand the function of and or how a SubForm works.
I'm not trying to slam you in any way, I just don't understand what is your trying to accomplish.
Horace Conti OP  @Reply  
    
4 years ago
Hi Scott, well I'm not taking any help as a slam, I just can't figure out how to make a Combo Box (1) Select a Name or Customer from the list in the Combo Box when clicked on it, then display that single Name or Customer in the SUB-FORM and that's it.  I'm working hard to get a firm grasp on RELATIONSHIPS, SUB-FORMS, and COMBO BOXES, but you're right I have a long way to go.  Richards video on "INVOICING" is exactly what I want to accomplish if the COMBO BOX would just place the single record I select after clicking on it,in the SUB-FORM, but it doesn't.  The SUBFORM just sits there on record 1 and doesn't respond.  Richard in the Video creates a SUBFORM but doesn't use it to select records for the SUBFORM, he uses the navigation buttons at the bottom.  I really like the Idea of using a COMBO BOX a Master Form with the SUBFORM embedded in it and controlled by a COMBO BOX.  That idea really saves space and puts a lot of information and control on the screen.  I just can't make it work.
Horace Conti OP  @Reply  
    
4 years ago
Scott, I made an error in my response.  I meant to say that Richard created a "COMBO BOX in the "INVOICING video and didn't use it to select records.  He selected records using the navigation buttons at the bottom of the SUB-FORM.  Everything I created following the "INVOICING" video works just fine as expected, but I can't make the COMBO BOX place a "single" record in the SUB-FORM.  Thanks for your help

Horace Conti
Scott Axton  @Reply  
        
4 years ago
So... the Combo Box is basically just a tool to select one item from a list of items.  We don't store the item, we store the ID.
Could be apples, pears, oranges, bananas.  Or Customers, or Events, or Orders, whatever.  

If I'm going to the store I'm not going to say I gotta pick up some 1 and 3 - I would say apples and oranges.
I don't want to have to remember what that ID is (that is for the computer to make the relationship) so that is where the combo box comes in.  

So the Combo isn't choosing or selecting any thing.  It's just 'storing' a piece of data, in this case the ID of the fruit.

In the Form > SubForm - the Relationship is created, in the tables underneath, using the ID.

I'd like you to go watch the Event Enrollment video.  In it Richard show some screen shots and diagrams that might help make things make more sense. Same concept only different use.  In that he shows how to use the same data to display things in a different manner.

Scott Axton  @Reply  
        
4 years ago
When you see Richard using the record selectors to move it is from Customer to a different Customer, the SubForm is changing as well because you are telling Access through the Relationship between the SubForm- "I only want to see this customers orders".
In the case of the Invoices video, that Customer may have many orders so the record selector for the SubForm is moving from order to order for THAT Customer.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 1:13:14 PM. PLT: 1s