Message box help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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
 
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?
 
Back
Top