Adding new data to a table with a form that also autofills

[aunttoots7]

I have form set up to enter reservations. I was able to get the form to autofill the Customer info based on an ID from an existing table. However, I now cannot add new customers on the form because they are not in the Customer table yet. Any suggestions??

[Missinglinq]

The standard approach to this would be, in the AfterUpdate event of the ID Control

• Use the DCount() function to see if a Record already exists for that Customer
• If it exists, autofill the data
• If it doesn't exist, open a Form to fill in the New Customer Data

This type of thing could be done with a Combobox, then use the Not in List event for adding the New Record.

Linq ;0)>

[aunttoots7]

The standard approach to this would be, in the AfterUpdate event of the ID Control

• Use the DCount() function to see if a Record already exists for that Customer
• If it exists, autofill the data
• If it doesn't exist, open a Form to fill in the New Customer Data

This type of thing could be done with a Combobox, then use the Not in List event for adding the New Record.

Linq ;0)>

Thank you for your reply Missinglinq! I'm just trying to learn to write code and really inexperienced. I have a little basic knowledge, but don't have a clue how to write your suggestion. I have created a form to add customers with no problem and have developed a macro to open it which I included in the Not in List event, but I'm not sure how to use the DCount function. Below is my information:
tCustomers
cboCustomerID
fReservations
I have the combo box (cboCustomerID) autofilling the rest of the customer information currently. I would also like to be able to add a new customer in the event they are not already in tCustomers. How would I write the code using DCount or do you need more information?