S sandylt Registered User. Local time Today, 12:31 Joined Mar 11, 2004 Messages 36 May 18, 2004 #1 I have two fields Complete Date and Status. If the status is changed to Complete then the Complete Date will fill in with today's date. Any Solutions?
I have two fields Complete Date and Status. If the status is changed to Complete then the Complete Date will fill in with today's date. Any Solutions?
P Pat Hartman Super Moderator Staff member Local time Today, 13:31 Joined Feb 19, 2002 Messages 47,320 May 18, 2004 #2 In the AfterUpdate event of Status: Code: If Me.Status = "Complete" Then Me.CompleteDate = Date() Else Me.CompleteDate = Null End If
In the AfterUpdate event of Status: Code: If Me.Status = "Complete" Then Me.CompleteDate = Date() Else Me.CompleteDate = Null End If
