I placed a custom toolbar ("myToolBar") with several standard buttons (Add, Edit, Delete, Save, Undo). When the user clicks "Add" button for instance, I want the following: 1) Add button is in pressed state, Edit button is disabled, Delete button is disabled, and Save button is enabled. I want to do something like this for all other buttons. How do I do this? I'm running Access 2003. I've tried the following and it gave a Runtime error 451 (property let procedure not defined and property get procedure did not return an object)
Private Sub myToolbar_ButtonClick(ByVal Button As Object)
Select Case Button.Key
Case "Add": MsgBox "Add clicked"
Button(3).Enabled = False
myToolbar.Controls("Edit").Enabled = False