Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a variable as reference to a form
Thank you, Andy I was so focused on creating a variable that I didn't see the obvious: just use the full name! With frmForm as Form it worked for me using Form_Test_0 or whatever in the call. And thats why external inputs are priceless when you hit a wall....- Zyborg
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a variable as reference to a form
Not quite... What currently is accepted is (requardless if the form is open or not): With form_Test_0 ----coding---- What I want it to accept is: varFormNo = 0 varForm = "form_Test_" & varform With varForm ----coding---- But if I do anything like .something.property = value, I get an...- Zyborg
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a variable as reference to a form
I would like to call a public procedure to do some modifications in multiple forms. The name of the forms are the same, but followed by a number. The name of the form and the number I'd like to put in a variable for the procedure to work with. I just don't know how to make the variable so VBA...- Zyborg
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)