I have a form with several subforms in it. I need the subforms to be connected to the main form when looking at the reports later on, so I've created a distinct variable for all the subforms to have (same as the main form).

I wish this will be done automatically - the variable will not be visible to the users in the subform, but will take the variable value using lookup from the main menu.

How this can be done?

Thanks

Ravid

P.S - the option on having a subform within a subform could really help me here...