subforms in a tabbook in a subform

[aidan]

Up until now I've put a tabbook on my main forms and subforms on each page of a tabbook when I want to display various tabledata related to the main form.

Now though I want to put the tabbook on a subform, so that I can include it from two different parent forms, but I thought perhaps I should base this subform on a query which draws everything together, and then just put these fields on the tabbook without having a seperate subform for each tab/related table.

However, I'm drawing and displaying seperate repeating groups in each tab, so I don't think this will work

Should I just have a hidden control on my subform to allow communication between the parent forms and the tabbook forms?

Thanks a lot in advance

Aidan

 

[aidan]

I'm sorry, I didn't explain very clearly. Parent contains SubA, and SubA contains SubSub01 and SubSub02. SubSub01 and SubSub02 need are foreign key related to Parent, not SubA. SubA is only necessary because of the use in 2 forms.

I can just use me.parent.parent for VBA, but what about linking the fields?

I'm going to test linking the fields tomorrow, but if anyone knows this won't work, then I wouldn't mind another reply.

Aidan