populate record base on another form

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

Guest

I have an "order entry" form.
There is a combo box for the custumer account.
If the customer is not on file, I have an option to "add" a new customer.
The "add" option opens up the customer form in data entry mode.

Is there a way to "transfer" the new customer to the "order entry" form once
the user finishes with the new customer entry and closes that form?

Right now, the user has to "select" the new customer from the combo box
after adding it.

Thank you for your help!
 
It depends on your set-up but I guess something like this should do (I
assume you "Add" Form is opened in Add mode and only one Customer is added):

In the Form_AfterInsert Event:

* Check that the "order entry" Form is open and if it is, requery the
ComboBox. (You might have done this already in your code)

* Check that the "order entry" Form is on NewRecord and if it is, assign the
ID value of the new Customer to the ComboBox value ...
 
Back
Top