Date Field Update Based on Start Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gumby - 13 Dec 2007 13:32 GMT

I would like to update A field with a End Date that is 45 days from
the Start Date.

I have tried is in the defualt value of my enddatefield

DateAdd("d", 45, DatesOfCOPStart)

However nothing happens.

I even tried a put this on a onclick event and a got/lost foucs
event.

Private Sub Command108_Click()
Dim UpdateDate As String

If IsNull([DatesOfCOPStart]) Then
Exit Sub
Else
UpdateDate = DateAdd("d", 45, DatesOfCOPStart)
Me.DatesOfCOPEnd = UpdateDate
End If
End Sub

It updates but only after I leave the record and come back. How can I
get the field to update on the spot?

David

Reply to this Message

ruralguy - 13 Dec 2007 15:48 GMT

You should really *not* have a field in your table that is calculated from
another field in your table. Just calculate the value any time you need it.

>I would like to update A field with a End Date that is 45 days from
>the Start Date.
[quoted text clipped - 23 lines]
>
>David

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message