Copying Fields Automatically

  • Thread starter Thread starter halfbodyguy
  • Start date Start date
H

halfbodyguy

Ok, I have a database that will have deliveries for lumber customers.

There will be an OriginalShipDate and a CurrentShipDate.

So I want the OriginalShipDate to be filled out when the order is
placed, and have it copy to the currentshipdate field.

That way when someone goes in to change the ship date later, the
original one is still intact as it originally was.

Any Ideas?
 
On the AFTERUPDATE event of OriginalShipDate insert the following code

me!CurrentShipDate.=me!OriginalShipDate

If the name of your fields is not as above change the above to the correct
name
 
No dice, it says that there is no existing macro...

Are you sure that the setup is right?
 
Back
Top