Copying over information from one form to another

  • Thread starter Thread starter Jon
  • Start date Start date
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?
 
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
 
Back
Top