I am setting up a database to monitor the progress of projects. For each project I have an "initial estimated completion date" and a "current estimated completion date". At the start of a project I want to be able to enter the "initial estimated completion date" and also, without having to re-enter the data, assign this date to the "current estimated completion date" as well.
Subsequently the "current estimated completion date" would be updated as the project progressed and we would be able to compare this date to the date we originally estimated.
Hope you can follow that, what is the best way to acheive this?
NB There are actually lots of different stages to each project with initial estimated dates and current estimated dates so entering the data twice would be quite time consuming.
thanks

Simply use the AfterUpdate event of the Initial Estimate controls to copy the value to the other control.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

If you only want to copy the date on the 1st data entry (specifying estimated completed date), you could add code to in AfterUpdate to only copy if the field/control is empty, therefore subsequent data entries would not change the estimated date.