Validation MsgBox appears 3 times. Why?

[cashe]

Hi all,

I have an input form and use validation to make sure the information being entered or not entered is correct. Some of my MsgBox's appear 2 or 4 times before they finaly go away. Why is this? The vb runs On Current so when the form is opened or saved the user gets the MsgBox. I've pasted an example of my code below:

If Supplier = "0" Then
Msg = "Please enter Supplier Details."
Style = vbExclamation
Title = "ManPower"
Ctxt = 50
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
End If

Any ideas why this happens and how can i sort it would be great.

Thanks

Cashe ;-)

 

[Isadore]

cashe: my guess is that using OnCurrent is causing your problems. Can you not have the validation handled on "afterupdate" of a particular textbox? onExit? etc?

 

[cashe]

Thanks Isadore,

I'll give it a go and let you know.

Cashe ;-)