VBA code to change the control visibility in a form from a function

[AmanKaur123]

Hi All

Hi All

The form name is stored in a variable FName which is a global variable. How can I use this variable to make the control visible/invisible in the form from a function stored in a module.

so basically something like:

FName.AgentTick.visible=true

where AgentTick is a control on the form whose name is stored in FName.

Thanks

[jwhite]

Try: Forms(VariableHoldingYourFormName).AgentTick.Visible =True

[aytee111]

Forms!FName!AgentTick.Visible=True