
August 18th, 2004, 09:30 AM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Referencing Controls with Access 97
Hi,
I have a form with a tab control with 9 tabs. I have worked out how to make a table visible in response to entry made on a combo box on my form. This is achieved via a function which is called as the form is opened and also when data entry is made via the combo box. I'm now trying to tidy up the code so that I reference each tab control using a variable.
This code works:
With Me(NewClaimTab)
.Visible = True
End With
However this code doesn't:
Dim strTabName as String
strTabName = "NewClaimTab"
With Me(strTabName)
Visible = True
End With
I get the message The expression Before Update you entered as the event property setting produced the following error: Method or data member not found.
Am I missing something simple here or is this simply not possible within Access 97?
|