Link to home
Start Free TrialLog in
Avatar of João serras-pereira
João serras-pereiraFlag for Portugal

asked on

how to address a subform in a form, from inside another subform

Hi -

I have a main form that contains a number (5) of subforms.

form the subforms I need to update the source of the other subforms like:

[Forms]![XL0].[xL1].Form.RecordSource = strSetSQL

[XL1] to [Xl5] are the subforms INSIDE the master form [XL0] and the names of the controls inside the XL0 form are ctl_L1 ... ctl_L5

the idea is that, after computing  [strSetSQL] I get to update the respective form

How do I do it?

/joao
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of João serras-pereira

ASKER

THANKS!!!!