Set Date Field

[CQCDave]

I have a form with is bound to a Task Details that is bound to a table Tasks. When the Status field on the form id changed to "In Progress" i want the Start Date field on the form updated to current date. i have very little VBA experience. This is what i have so far.


Private Sub Status_AfterUpdate()
If Me.Status = "In Progress" Then
Start Date = [Date]
End If
End Sub

Thanks, in advance, for the help.

[RuralGuy]

I'll start the responses with a link to Reserved Words. Words you should not use for fields in tables or controls on forms.
http://www.allenbrowne.com/AppIssueBadWord.html

[RuralGuy]

Since this thread has been marked as Solved, can I assume it was your choice of Reserved words that was causing the issue?