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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Them delivery services - some good, some not so good 3
SteamDeck 10
Changing Field values after a report is printed 2
HOW DO I GET A FIELD TO AUTOMATICALLY FILL IN? 2
Excel Populate Delivery Note 0
Auto fill field in subform (like Unit Price) 1
Automatically copy data from one form field to another 4
Deny changing value in field, based on values of multiple fields 4

Back
Top