button wizard

[enrico via AccessMonster.com]

how do you put a condition on a button? like if you click "yes" the button
will perform an action and if "no" it will not perform nothing

 

[Jeanette Cunningham]

Hi enrico,
you can use a message box.

Private Sub BtnName_Click()
If vbYes = Msgbox("Do you wish to continue?", vbYesNO, "Continue?") Then
DoCmd.OpenForm "NameOfForm"
Else
End If
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia