Suppress error message

  • Thread starter Thread starter access_questions
  • Start date Start date
A

access_questions

Hi All,

I have a combo box, which when the user types in a contact name which is not
in the list, i want a msgbox saying "Contact not in database, please enter
now" then a pop up form [frmContacts] to open up for the user to type the
details in.
I have this working, but keep getting the access error message about not in
list as well as mine - how do i suppress this?
I tried using SetWarnings in a macro, before the msgbox action and also
before the openform action but neither of these worked.
Any suggestions much appreciated!

Kirstie
 
oh, and i also want the combo box list to refresh with the new data!

ta!

kirstie
 
Back
Top