Add record to combo box

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

Guest

I have a combo box based on the table "Customers". When I add a new job, if the customer isn't in the list, I have a macro which opens New Customer form in "add" mode. When I add the new customer and close the form, the customer doesn't appear in the combo box until I close the "new job" form and re-open it. This is incredibly awkward

Whats missing?
 
You can issue a Requery on the combobox. Not sure it you can do this using a
Macro, but you can with VBA.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jim said:
I have a combo box based on the table "Customers". When I add a new job,
if the customer isn't in the list, I have a macro which opens New Customer
form in "add" mode. When I add the new customer and close the form, the
customer doesn't appear in the combo box until I close the "new job" form
and re-open it. This is incredibly awkward.
 
Back
Top