Generating New Record in different Table when Item is not in List

[Guest]

I have a customer table setup in the fashion of a contact list. Most of my
forms need to access the information in it via a list box. I want to set
these list boxes to generate a new record in my customer table if the name
that is entered is not currently in that list. By using the event option "On
not in list" I'm able to get the form for the customer table to open but when
the new data is saved and the Customer form is closed the information is not
available to the list box. How do I get it to update the list box without
having the user start from scratch on that particular form?

 

[Allen Browne]

Answered in Secret Squirrel's question 1 hr later