Copying over information from one form to another

J

Jon

Hello, I'm sure there are many ways to do this but I can't
figure out any of them. I'm trying to copy parts of one
record on a table (addresses) to another table (orders).
The addresses and orders are already linked by a
clientID. While addresses may change, I want the address
information on the order table to act as a log of where we
actually sold things to and where they went. I've got 2
addresses to log on my orders, billing and shipping.
What's the best way to copy this information over?
 
K

Kipp Woodard

You would choose the appropriate event to capture the address. For
instance, if you have a shipping department and they have a form that they
use when they ship, then use whatever button they might click to indicate
that a shipment has shipped to execute this code (something like it):

Me.txtShipTo = Me.sfmCustomers.form.txtCustomerName
Me.txtShipToAddr1 = Me.sfmCustomers.form.txtAddr1
Me.txtShipToAddr2 = Me.sfmCustomers.form.txtAddr2
Me.txtShipToCity = Me.sfmCustomers.form.txtCity
Me.txtShipToState = Me.sfmCustomers.form.txtState
Me.txtShipToZIP = Me.sfmCustomers.form.txtZIP
 
Top