Message box help

L

lmossolle

I have a workorder form which has a Combobox, which generates all the
information from a customer table. How can i put a message box that will ask
the user if all the information is correct? If select yes he can continue, if
selected no, it will open the form to allow the user to modify the changes?

Thanks!!!
 
A

Allan Murphy

You could use coding similar to this

Dim Msg, Style, Title, Help, Ctxt, Response

Msg = "Is all the information correct?" ' Define message.
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "Warning - Check Information" ' Define title.

Response = MsgBox(Msg, Style, Title, Help, Ctxt)

If Response = vbYes Then
coding for the user to continue
Else
coding to open form
End If
 
L

lmossolle

The form the users would have to change is customers, how do you add the
coding to open the customers form based off the name selected? Also can you
give 30 seconds to allow the user to look before the message appears? Would
this be the on click?
 
Top