Can't do that at the Table level, but in your form you can use the
AfterUpdate event of the first field to assign a value to the 2nd if no
value has been assigned:
Private Sub 1stpromisedDate_AfterUpdate()
If IsNull(Me.CurrentPromisedDate) Then
Me.CurrentPromisedDate = Me.[1stpromisedDate]
End If
End Sub
It might be better to use a Number field for the current one instead of a
date. It would contain the number of days different from the original date:
negative if early, zero if the same, positive if delayed. This field would
default to zero. To show the actual current promised date, you would then
use:
DateAdd("d",, [DelayDays], [1stpromisedDate])
This structure avoids the issue of the dependency between the two in the way
the data is stored.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"hyphen" <p4**@hotmail.com> wrote in message
news:55*************************@posting.google.co m...
I have set up two date fields in a table:
1stpromisedDate and CurentPromisedDate
The first field is to record the 1st promised delivery date of a
supplier and the second is to record the current promised ate from a
supplier. In an ideal world these two dates will always be the same,
but in reality the delivery date will change. Therefore I want to set
the currentpromisedate to default to the 1stPromiseDate value. I need
to be able to overwrite the default value as and when the delivery
date changes.
How do I do this?