Access Control over another tab

[static]

Yeah. Silly way to go. But. I've enjoyed my time here. Hope I haven't upset anyone too much and helped a few...

 

[Pat Hartman]

A subform control can only contain one form

Older versions of Access allowed 3 levels of nesting but newer versions allow 7 (I think)

Of course only a subform in single view can have a subform regardless of Access version. So if your form/subform is continuous or DataSheet, It cannot have any subforms at all. That would force Access to render the subform for each visible instance of the continuous or DS subform so that is what causes the restriction.

 

[khurram7x]

... Bookmark this page for the correct syntax http://access.mvps.org/access/forms/frm0031.htm

As already noted by others, this all goes out the window if you use the inbuilt navigation form as it dynamically loads the forms as subforms.

It worked, thank you

 

[khurram7x]

...and don't fight guys please... peace and patience ))))))))))

 

[isladogs]

Yes I agree. Good luck with your project