Add record to combo box

[Jim]

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?

 

[Douglas J. Steele]

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!)

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.