Calling a Form by a variable

  • Thread starter Thread starter SurveyorinVA via AccessMonster.com
  • Start date Start date
S

SurveyorinVA via AccessMonster.com

Good day all,

I have a form that is loaded based upon an option in a table. For example,
depending on the layout the user wants to see they can have either frmTodayA,
frmTodayB or frmTodayC loaded.

When I call the form via:
txtMyForm = "frmToday" & txtLayoutDesignation

Docmd.Open acForm, "txtMyForm" everything works fine

Now I want to change the source object of a subform on my txtMyForm, and I
thought I could use the following designation

Set frmtoday = Forms(txtMyForm)

frmtoday!Mod1Window.SourceObject = txtModule1

Unfortunately it gives me the following error: "The setting you entered is
not valid for this property"

What would be the proper way to reference the form that can be variable?

Thank you in advance.
Chris
 
If ModWindow1 is the name of a control containing the subform and txtModule1
is a string representing the name of a valid form, table, select query or
SQL, then:

frmtoday.Mod1Window.SourceObject = txtModule1

should work (if frmtoday is open).
Note the use of . rather than !, not sure if it makes a difference in this
case or not.
 
Back
Top