Combo Box update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top