New Customer Entry

[Waterdog]

In my form, I've got fields for customer info. However, if I enter in a CustomerID that doesn't exist in the customer table then I get an error. In my old Access database that I had, I clicked on a button that opened up a new form. Type in the info and close the new customer form. Then the data would be in the customer table. What I'd like to do is simplify things. Is it possible to set it up to where I type in a customer ID and on losing focus it creates a new record in that customer table so when you continue typing in customer info it just adds the data instead of giving me an error? Either that or apply the same principal by means of clicking on a check box that could indicate the customer is new?

[June7]

What you can do is use the combobox NotInList event and with some code, open the customer form, enter the new customer info, close the form, requery the combobox so the new record is available.

https://www.accessforums.net/access/...ate-55139.html

Is the CustomerID generated by autonumber or is it a custom unique ID assigned by you?

[Waterdog]

The CustomerID is an existing number. Otherwise I'd just set that field to autonumber if I could. I was trying to consider different options. This form has a subform to it in which you can enter in various products that the customer is returning. Is it possible to code it in such a way to where I can just type in the customer info and when I change focus to the subform that it could run some code to add that customer to the database. Otherwise as it currently stands I can type a customers info in but as soon as I try to select the subform, that's when it gives me the error basically saying that customer isn't found in the customer table.

[June7]

The method I referenced is the best I know.

[Waterdog]

Alrighty. Appreciate the input. Thanks!