Solved Set combo box value after closing another form (1 Viewer)

accessonly11

Member
Local time
Tomorrow, 00:49
Joined
Aug 20, 2022
Messages
91
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.
1662529693815.png
 

accessonly11

Member
Local time
Tomorrow, 00:49
Joined
Aug 20, 2022
Messages
91
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:49
Joined
May 7, 2009
Messages
19,246
see this demo, i create new form NewCustomer.
 

Attachments

  • sale purchase.accdb
    2.1 MB · Views: 90

Users who are viewing this thread

Top Bottom