Opening a MsgBox in a form

[Russell G]

Hi

Please help..

I have a form updating a table. When data is entered into a Combo box, I would like to use the BeforeUpdate or AfterUpdate (??) to verify if this information already exists in "another" table..not linked to the table the form is updating.

If the above it true I want a MsgBox to display a warnig message. On cancelation of the MsgBox the data must still be accepted as vaild.

I can not get this right...any comments???

[NeoPa]

Using a MsgBox will not effect the outcome of the data unless you program Cancel=True in response.
In other words, you shouldn't need to worry about it unless you put in code yourself.

It's hard to be more specific in the absence of more details but I hope this helps.

[MMcCarthy]

Sub temp()
MsgBox "And now ...", vbOKCancel + vbExclamation
MsgBox "OK"
End Sub

If you run the above as a test you will see that cancelling the msgbox doesn't do anything unless you take the resulting integer returned and do something with it like below.

Sub temp()
Dim rslt As Integer
rslt = MsgBox("And now ...", vbOKCancel + vbExclamation)
If vbOK = -1 Then
MsgBox "OK"
End If

End Sub

Hi

Please help..

I have a form updating a table. When data is entered into a Combo box, I would like to use the BeforeUpdate or AfterUpdate (??) to verify if this information already exists in "another" table..not linked to the table the form is updating.

If the above it true I want a MsgBox to display a warnig message. On cancelation of the MsgBox the data must still be accepted as vaild.

I can not get this right...any comments???