Form name as string

U

UpRider

This should be easy but I can't get past the errors....
Below is a simplified version of what I am trying to do.
The code is in a module.

dim frmName as string
frmName = "Report1"
Forms!frmName.visible = false

Access tells me it can't find a form named "frmName"
How can I use a variable here?

UpRider
 
R

Rick Brandt

UpRider said:
This should be easy but I can't get past the errors....
Below is a simplified version of what I am trying to do.
The code is in a module.

dim frmName as string
frmName = "Report1"
Forms!frmName.visible = false
Click to expand...

Forms(frmName).Visible = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

for each control iteration in form design mode 4
My string does not want to execute 5
Subform control reference in Function 5
Need an expert 1
type mismatch error 2
Set dynamic reference to a control in a public function 1
declare a form so that you can reference it's controls 1
Help pls - error on code and I dont know how to fix :) 5

Top