Combo Box update

T

TinleyParkILGal

Professionals: I have a form for orders which contains a combo box for
customers. If the customer is not in the lookup of the combo box the form
contains a command button allowing the user to add a new customer.

When the user closes the customer form, I need that new customer to appear
in the combo box but it is not.

Thank you for your valuable time and assistance.
 
D

Douglas J. Steele

Try issuing a Requery on the combobox.

Assuming your order form is open, and that the customer combobox is named
cboCustomer, it would be something like:

Forms("Orders").cboCustomer.Requery
 
Top