Solved Set combo box value after closing another form

[accessonly11]

hi guys,
how it is possible that when user add a new customer name and mobile number, and click on save/close button on AddNewCustomer form, it save the record, then close form, and then set combo box value of customerID on main form which is newly entered.

 

[Gasman]

Use the NotInList event

 

[accessonly11]

i tried this in AddNewCustomer form Unload event, and working for me

Private Sub Form_Unload(Cancel As Integer) Forms!Orders!CustomerID = CustomerID End Sub

 

[arnelgp]

see this demo, i create new form NewCustomer.