asked on Refering to a form using a variable.
Hi
See the code below. I want to enter into the sub with the name of the form as a string. I will need to refer to that form directly later. I wish to do this by using syntax similar to what the code below.
I would appreciate help in fixing that code.
Thanks
See the code below. I want to enter into the sub with the name of the form as a string. I will need to refer to that form directly later. I wish to do this by using syntax similar to what the code below.
I would appreciate help in fixing that code.
Thanks
Public Sub CheckDuplicates(ByVal FormName As String, ByRef lblCommunicate As Label)
Dim TheForm As Form: Set TheForm = Forms(FormName)
Microsoft Access
Last Comment
Gustav Brock
Dim TheForm as Form = Forms(FormName)
ASKER
Thanks for your reply, but it did not work. The syntax failed.
I used the following but got "Invalid use of property"....
Public
I used the following but got "Invalid use of property"....
Public
Sub CheckDuplicates(ByVal Const_FormTable As String, ByRef lblCommunicate As Label)
Dim TheForm As Form: TheForm = Forms(Const_FormTable)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for your replies, but I have not found resolution to my original question.
I have re-read it. I believe that I have phrased the question correctly.
I am using Microsoft Access 2013.
I have re-read it. I believe that I have phrased the question correctly.
I am using Microsoft Access 2013.
are you getting an error? what is the error?
the form must be open, and this should work
Dim TheForm As Form: Set TheForm = Forms(Const_FormTable)
debug.print TheForm.Recordsource
the form must be open, and this should work
Dim TheForm As Form: Set TheForm = Forms(Const_FormTable)
debug.print TheForm.Recordsource
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.