asked on Access - Linked forms
I have a situation whereby I need 3 linked forms. This has arisen because of this scenario:
A vehicle will be sent out to several locations, and at each location it will pick up several items. So I need to record:
Load
Collection
Collection Items
So there will be one or many Collections per Load, and one or many Collection Items per Collection.
What is the best way to enter and display these details? Normally I would contemplate using subforms, but with 3 levels this could become unwieldy. Does anybody have ideas or examples of a good solution please
A vehicle will be sent out to several locations, and at each location it will pick up several items. So I need to record:
Load
vehicle details
driver
date of collection
driver
date of collection
Collection
Customer Site
Collection Items
Item collected
Quantity
Quantity
So there will be one or many Collections per Load, and one or many Collection Items per Collection.
What is the best way to enter and display these details? Normally I would contemplate using subforms, but with 3 levels this could become unwieldy. Does anybody have ideas or examples of a good solution please
Microsoft Access
Last Comment
Rick Danger
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am happy to award full points for this - thanks fo rthe answer.
However, can I ask a cheeky extra question please? If there was a combo box in the 3rd level subform, and its value was dependent upon a value in the 2nd subform, how would I refer to this. And just to complicate matters, this whole form will be within a Navigation Form. If I need to ask this as an extra question, please let me know.
However, can I ask a cheeky extra question please? If there was a combo box in the 3rd level subform, and its value was dependent upon a value in the 2nd subform, how would I refer to this. And just to complicate matters, this whole form will be within a Navigation Form. If I need to ask this as an extra question, please let me know.
Me.parent.otherChild.form.
Can you post a sample db with no sensitive data to illustrate your layout?
I won't be at a computer to look at it for the rest of the day, so if you need more immediate help, go ahead and post a new question.
Can you post a sample db with no sensitive data to illustrate your layout?
I won't be at a computer to look at it for the rest of the day, so if you need more immediate help, go ahead and post a new question.
Fwiw, I don't think the navigation form will really complicate things much.
ASKER
OK - I'll implement the solution that you have provided, then post another question.
Thanks for your help, much appreciated!
Thanks for your help, much appreciated!
Main Form: Load
Subform 1: Collection (linked to the main Load form)
Subform 2: Collection Items (Linked to the Collection subform, but placed next to or underneath rather than nested in the collection subform)
Code in the Current Event of the Collection subform would be used to control the filtering of the collection Items subform, so that when the user navigates between records in the Collection subform, the Collection Items subform displays those items associated with the currently selected collection.
See the following question for details... the author has uploaded an image illustrating a sample layout, and the author's final post contains the code that makes this work:
https://www.experts-exchange.com/questions/27512608/2nd-and-3rd-Sub-Sub-Form-Not-Working.html