Hi,
I have a button named bttn4 on a form which generally is not visible. (The Visible setting on the Property Sheet is set to "No") The button is to open another form when clicked.
I have a tick box field on the form called [BML Driver]
If BML Driver is ticked, I want the button to show. If BML Driver is not ticked I want the button to remain hidden.
I have put the following code on the On Current event ...
Code:
Sub Form_Current()
'show bttn4
If Me.[BML Driver] = "yes" Then
bttn4.visible = True
bttn4.SetFocus
Else
bttn4.visible = False
End If
The bttn4.visible seemed to work OK, but when I added the criteria of the tick box it stopped working !!!
Any help or advice would be appreciated.
Cheers
Stuart