Code with If statement to check a check box has syntax error

[sleake]

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.

 Private Sub Form_Current()
If([txtStatus]= "in Process" And Date() > [dteDate_Hard] Then
[chkOverdue] = True
Else
[chkOverdue] = False
End If
End Sub

Also, should I name the field/control Hard_Date to avoid conflict with the reserved name?

[June7]

There is a solo parenthesis after the If and should be a space there.

Why save this calculated result to table? Just calculate in ControlSource when needed.

Not seeing a conflict with reserved word in that code but yes, avoid naming anything with reserved words.

[sleake]

The check box is unbound. (The form is opened occasionally to display the status of records that are "In process," so no need to put it in a table.)

I deleted my results and questions, as I'm find errors in naming. Have a meeting this morning, but will post back after the cleanup of names. I also will have questions about two DateDiff calculations in unbound controls.

[hapm]

The syntax as shown IS incorrect. There is a , to much. If in VBA isn't like IIf:

If [txtStatus] = ”in Process” And Date() > [dteDate_Hard] Then
    [chkOverdue] = True
Else
    [chkOverdue] = False
End If

And as June7 already stated you should use a calculated field in a query (no value to save to a table here) to get a field you can bind to the chkOverdue checkbox. Its faster and cleaner.

[June7]

If the checkbox is unbound and code is used to set value, then all records will display the same value. Is the form in datasheet or continuous view? Better to use expression in ControlSource property.

[sleake]

Because of your suggestion, found my way to the Expression Builder, and this is now working as the Control Source: =IIf([txtStatus]="In process" And Date()>[Date_Hard],True,False)

I'll do a separate post of my DateDiff questions.

Thanks for guiding me to the answer.