Hey All,
If I would have my way I'd set-up a form like this (sub bullets would be subforms):
- Main Form (A)
- Single Form Subform (B)
- Single Form Subform (C)
- Datasheet Subform(s)
The datasheet subforms are inconsequential as the real problem is that Access doesn't allow the 3rd layer of subform as a single subform (characterized by the square bullet above). So to "resolve" the problem, I am separating Main Form A and so Form B no longer has a Parent-Child relationship with Form A, by the Case ID field.
By design, when Form B opens Main Form A is still open, so I set the Case ID field in Form B to look up the value that's currently in Main Form A to pass the value. But unfortunately the value isn't being passed.
There is essentially 2 things I want
- While form A is opened, when form B is opened I want the record(s) in Form B to be the same record that's currently in Form A via the Case ID field.
- If Form B doesn't have any corresponding records to Form A (as in there is no matching Case ID fields in both forms), I want the Case ID in Form A to pass its value to the Case ID field in Form B
- If I go to a new record in Form B, I do want the same Case ID field to be passed from form A
I hope this makes sense. I will clarify anything that doesn't seem clear. Thanks.