msgbox responses

[Guest]

I have a box with 2 available buttons (vbOKCancel). How do I capture the
users reponse to "OK" . I want "OK" to open another form. ("Cancel" does
what it should) Thanx - David

 

[MikeB]

Look at the MsgBox Function. It returns the value of the button click..

 

[Lynn Trapp]

If MsgBox ("Your Message here", vbOKCancel) = vbOK then
DoCmd.Open "YourFormName"
Else
-- Do something else here
End If

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html