Could someone please help me with the following?

I have a user form

3rd field or tab down is a combo box field (cboPayable)

I have the properties for the cboPayable ( matchrequired set to true)
-all the selections are via rowsource from another sheet


Is there anyway that if the user enters something that doesn't match
can get a msg box to popup and ask them if they want to add that to th
accounts.

The problem i am having is i am trying to use the exit event in th
cboPayable. And when i exit or tab from that field( and the valu
doesn't match then) a microsoft message box appears that says invali
property use. then my msg box comes up. But not until i close al
forms. is there anywya to bypass this message from microsoft.

Thanks for any hel

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=47758