Autosave in a Form

[zacharyjunior]

I have a customer complaint form that has numerous customer data fields. The first field is a frop down box that links back to the customer table. When the operator selects a customer it auto populates the customer data. From time to time we will run across a new customer that is not in the table. I have a command button that opens the customers table (form view) and allows the operator to enter a new customer. My problem is when the operator is finished entering the data, and trys to select the newly created customer, the customer is not there. The complaint form has to be completely closed and reopened before the new customer will show up in the drop down box.

How can this be fixed?

Thanks.

 

[Rich]

Article ID: Q161007

 

[David R]

Or use Requery.