Good Afternoon All,
I am trying to reference a field in a table of data type Date/Time. However if the field contains empty values an error message is raised indicating that "datatype mismatched in criteria expression"
can anyone guide me how to get around this problem as I would have some empty fields
Here's the code I am using:
Private Sub Command17_Click()
DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = '" & WorkersName & "' And Datevalue(tblSignin.DateCreated) =# " & DateValue(Date) & "#"
End Sub