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

Problem was resolved, what had happen is in the middle of doing a test for which this program had been written a system crash occurred. When the line of code runs it looks for the last report to generate from that and since the report was not there it caused an error. By deleting the last report the code ran fine and continued working.