open subform

[Guest]

I have a form with several unbound subforms. I want to pass in a string value
specifying the subform I wish to load on opening the form.

If the variable holding that value is FormToOpen, how do I set the form? The
following doesn't work:

set frm= Me.FormToOpen.Form

What is the syntax?
Thanks again!!

 

[Marshall Barton]

I have a form with several unbound subforms. I want to pass in a string value
specifying the subform I wish to load on opening the form.

If the variable holding that value is FormToOpen, how do I set the form? The
following doesn't work:

set frm= Me.FormToOpen.Form

What is the syntax?

That's kind of vague so I'm not sure what you trying to do.

I think you might want to set the subform **control**
SourceObject property to the name of the form:

Me.subformcontrol.SourceObject = FormToOpen

 

[Alex Dybenko]

should be:
set frm= Me(FormToOpen).Form