Hello,
I am hoping to get som really clear guidance on an issue I am having. I am pretty new to programming in any sense of the word but with the help of a friend I was able to develop a script that runs when a form is opened. What I would like to do is modify this script so that "IF" the result is False the button not only will not be enabled but would not even be visible to the user.
The script I currently have (and it works) is as follows:
If User.AccessID = 1 Then
Me.cmdUserSettings.Enabled = True
Else
Me.cmdUserSettings.Enabled = False
End If
Exit_Form_Open:
Exit Sub
Err_Form_Open:
MsgBox Err.Description
Me.Visible = True
Resume Exit_Form_Open
The other item I am wanting to do is add an additional button that will act exactly the same way. Can I add the information for the button into the script that I have or do I have to script it a different way?
Any help and guidance would be greatly appreciated.