Use form field result as default value of a another field on same form

[EEK]

I have a problem. I have a form, being used as a subform. I have an "Original Date" field and a "Revised Date" field. I want the value the user types in the "Original Date" field to be the default value in the "Revised Date" field.
I used default value "=[OrigDate]" but that doesn't work, it just shows a blank. Both "Original Date" and "Revised Date" are in the subform.
Is there any way I can default "Revised Date" to the "Original Date" entry (and let the users change the "Revised Date" later on)
Thanks
EEK

 

[KeithG]

you can use the after update event from the Orig Date text box to update the Revised date

 

[EEK]

KeithG, thanks but wouldn't the AfterUpdate event update the revised date every time it was updated? I just want to have it default to the orig date when the orig date is filled in the first time.

 

[KeithG]

Is the Original Date going to Change?

 

[EEK]

It is possible that the Orig Date may change, though unlikely

 

[RuralGuy]

Then only change the RevisedDate when it has no existing value.

 

[EEK]

I thought that setting a default value in a field on a form to the entered value of another field on that same form would be easy! Interestingly enough, if you set orig date to now() and set default value of revised date to [origdate] it works, so I guess it has something to do with the entered value.
I will try the after update event and update revised date if it is blank.
Thanks for all your help.