Run-Time Error '3075' Syntax Error
I am getting a missing operator error when I try to run this line of code:
If DCount("*", "Sample Info", "[REPORTNUM] = " & DLookup("[REPORTNUM]", "Specimen")) = 0 Then
' trying to recover test deleted from db only
Beep
MsgBox "Database sample information for the selected test has been deleted from the database; results cannot be displayed.", vbInformation, "Unrecoverable Test Results"
Call KillFile("TESTED.TXT")
Exit Function
The program was running fine a few days ago and now it is giving me this error. Any help would be appreciated