Yes, I've tried to set criteria with both "0" and "-1" in lieu of TRUE & FALSE but same results.
Allen wrote a calendar function years ago that I continue to use that sets the value of text boxes bound to date fields.
Code:
Public Function CalendarFor(txt As TextBox, Optional strTitle As String)
'On Error GoTo Err_Handler
'Purpose: Open the calendar form, identifying the text box to return the date to.
'Arguments: txt = the text box to return the date to.
' strTitle = the caption for the calendar form (passed in OpenArgs).
Set gtxtCalTarget = txt
DoCmd.OpenForm "frmCalendar", windowmode:=acDialog, OpenArgs:=strTitle
Exit_Handler:
Exit Function
Err_Handler:
MsgBox "Error " & Err.Number & " - " & Err.Description, vbExclamation, "CalendarFor()"
Resume Exit_Handler
End Function
I've moved the target records around in the DB such that the query would be operating on different records in the DB but nothing changed.