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 
Form Subform Interaction Knowledge Gap
James Chessher 
        
8 months ago
Have: Form with a SubF based on the same Query and Table.  
Goal: Display all Records on ContinuousSubF. Select on SubF, Full Record data appears up top (- which is exactly what I want).
Issue: I can make Form display Record, but SubF only displays that record.
If I clear out the Master/Child connection, All Records display via Query, But the Form will not display the Record for editing.
Every video I have found explains: (examples)  Starships to Crews. Employees to Mileage. etc.   I need Same Table Form-SubF interaction.  
I am resisting the Select Record and Open a New Form window.  Am I wrong about this way of thinking? Just a Point in the Right direction please. My search efforts are in vain.
James Chessher OP  @Reply  
        
8 months ago

Raymond Spornhauer  @Reply  
          
8 months ago
James

See if this video helps.  Synchronize Subforms.
Raymond Spornhauer  @Reply  
          
8 months ago

Raymond Spornhauer  @Reply  
          
8 months ago

Donald Blackwell  @Reply  
       
8 months ago
Alternatively, you don't need any subforms.

Make your continuous form as your main form first with the fields you want to show in it in the detal section of the form.

Then, In the form header, create the fields for the single form.

The only caveat is that in your continuous form, you'll need to name your controls something slightly different (i.e. if the field name is FirstName, make it FirstNameC to indicate that's the field in the continuous form.)

If you're going to do all your adding/editing in the single form, then make sure to set the locked property to true in all the controls on the continuous form so that you can still click in those fields but all editing will occur up top.

This is similar to what Richard talks about in his Split Forms video when he talks about better ways to create the split form effect.
Raymond Spornhauer  @Reply  
          
8 months ago
James

For what you're describing... I don't think you need Sub-Form at all.  (Reference the pictures I attached)

Make your form a Continuous Form with the fields you want to see in the Details section.

Then in the Form Header, show the arrange the fields in the way you want to see them.

As described in the video... you can lock the fields in the Details section so no changes can be made in that part of the form.

Keep in mind that because you have fields with duplicate values, you'll want to name them appropriately.  

IE:
Maybe keep the normal names for the Fields in the Form Header if you plan to use code here.  Then you can either not worry about the names in the Details Section, or name them something like Field2.

Hope this helps,

-Raymond
Raymond Spornhauer  @Reply  
          
8 months ago
Donald

I was just writing that up... to go with the pictures I posted... lol
Donald Blackwell  @Reply  
       
8 months ago
Raymond lol, my slow internet connection let your images go up first, lol.
Richard Rost  @Reply  
          
8 months ago
Chop chop! LOL.

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 4:35:36 AM. PLT: 1s