Populating A Fileld Depending On The Value Of Another ?

Hi

I have an after update even on a field on a form.


If the user selects Clsoed in obe filed it autoupdatwes another filed with the date and time of closure as follows:-

Private Sub OPENCLOSED_AfterUpdate()

If OPENCLOSED.Value = "Closed" Then
DATECLOSED.Value = Now()
End If
End Sub

However I need another statement (else), so that if he changes the status back to open then the DATECOSED FIELD is cleared.

Does this make sense.

I may have many more questions as Im just getting back into access after a 10 year break :eek:

Thanks

Jimmy