Update field after new record created

P

Pip'n

I have a form that contains dropdowns called customer, truck, and in a
subform there is a dropdown control called operation. With each of these
controls there are fields that are updated when a selection is made. I would
like to implement the following functionality for each but will only use one
example.

For instance, currently when a customer that is not on the list is entered
into the customer field, the new customer form opens and allows for this new
customer to be added. I would like the customer that was originally entered
in the dropdown to automatically be copied to the customer ID field of the
New Customer form. Then when the user adds the customer and clicks a button
to return to the main form I would like the fields related to the customer
dropdown to be updated with what was added in the new customer form.

Thanks in advance
 
Top