I am getting a syntax error for the following code. I want a check box checked if a record status is "In process" and today's date is greater than the date in the field [dteDate_Hard], indicating that the item is overdue.
Also, should I name the field/control Hard_Date to avoid conflict with the reserved name?Code:Private Sub Form_Current() If([txtStatus]= "in Process" And Date() > [dteDate_Hard] Then [chkOverdue] = True Else [chkOverdue] = False End If End Sub