Copying Fields Automatically

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?
 
A

Allan Murphy

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
 
H

halfbodyguy

No dice, it says that there is no existing macro...

Are you sure that the setup is right?
 
Top