Constructing commands from variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am constructing the following
forms!formname!pageno.visible=False
from variables held in a table. Specifically the pageno and False/True are
picked up from the table. I'm getting formname using CodeContextObject.

I can build forms!formname!pageno.visible=False by concatenating the
variables and constants, but that gives me a single variable, say xSTR
containg the string.

How can I then get the module to interpret xSTR as
forms!formname!pageno.visible=False?
 
Colin said:
I am constructing the following
forms!formname!pageno.visible=False
from variables held in a table. Specifically the pageno and False/True are
picked up from the table. I'm getting formname using CodeContextObject.

I can build forms!formname!pageno.visible=False by concatenating the
variables and constants, but that gives me a single variable, say xSTR
containg the string.

How can I then get the module to interpret xSTR as
forms!formname!pageno.visible=False?
Click to expand...


Instead of constructing the entire statement, try just using
this kind of statement:

Forms(formname).Controls(controlname).Visible=variable
 
Back
Top