populate record base on another form

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

Van T. Dinh

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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top