combobox no match - add to new record?

  • Thread starter Thread starter JAson
  • Start date Start date
J

JAson

Hello, I have a form with three lookup combo boxes, these
are PhoneNumber, AssociateExt, and LastName. These are
unbound and are just used to locate existing records in my
Contacts table. I do have each of these fields somewhere
on the form and in the event that the data entered into
one of the lookup boxes isn't on the list - Message
box "Not on the list, Would you like to add? then
automatically add a new record to the Contacts table and
then paste that data into the corresponding field on the
form.

Thanks in Advance for any help provided.
Jasong in AZ
 
JAson said:
Hello, I have a form with three lookup combo boxes, these
are PhoneNumber, AssociateExt, and LastName. These are
unbound and are just used to locate existing records in my
Contacts table. I do have each of these fields somewhere
on the form and in the event that the data entered into
one of the lookup boxes isn't on the list - Message
box "Not on the list, Would you like to add? then
automatically add a new record to the Contacts table and
then paste that data into the corresponding field on the
form.
Click to expand...

Set the combobox's LimitToList property True, have a NotInList event
querying the user for additional values if necessary and a confirm, and
set the Response property to acDataErrAdded if the confirm was positive.
 
Back
Top