Update a date field after updating another field.

[Guest]

Ok I have 2 fields that I need to work with. One being a "Status" field and
the other being an "ending date" field. What I'm going for is to update teh
"ending date" field with the current date when the "Status" field is changed
to 'Closed'.

The "Status" field is contents from another table being named "Status". The
"Ending Date" field is contained in my main table "Changes"

Also I'm working with access 2003, and an mdb file (if that helps at all)

 

[Guest]

Tim,

In the AfterUpdate event of the Status field:

If Me![Status] = "Closed" Then
Me![EndingDate] = Date()
End If

If the underlying Status field is actually numeric, change "Closed" to the
appropriate number associated with the text "Closed", without the quotes,
e.g.:

If Me![Status] = 2 Then
Me![EndingDate] = Date()
End If

Sprinks