• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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
vehicle details
driver
date of collection

Collection
Customer Site

Collection Items
Item collected
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
0
rick_danger
Asked:
rick_danger
  • 4
  • 2
1 Solution
 
mbizupCommented:
How about instead of 'nested' subforms, having side-by side related subforms for the Collections and Collection Items:

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:
http://www.experts-exchange.com/Database/MS_Access/Q_27512608.html
0
 
mbizupCommented:
Actually, here's a working sample - from the same question, with the solution that came out of the thread.

Try clicking different records in the Contract Years subform - and see how it controls the filtering of the other two subforms...
Form-Parent-Child-Grandchild.mdb
0
 
rick_dangerAuthor Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mbizupCommented:
Me.parent.otherChild.form.textboxname for the combo box reference.

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.
0
 
mbizupCommented:
Fwiw, I don't think the navigation form will really complicate things much.
0
 
rick_dangerAuthor Commented:
OK - I'll implement the solution that you have provided, then post another question.

Thanks for your help, much appreciated!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now