Suppress error message

  • Thread starter access_questions
  • 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
 
A

access_questions

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

ta!

kirstie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top