I get a syntax error for this
LockNum is of DataType Number
I used macro to code the form. It just checks a filed value for 1 or 0. It had been working but just today an error poped-up.
Code:
DLookUp("[LockNum]","tblImportLock","[Open]=1")
I used macro to code the form. It just checks a filed value for 1 or 0. It had been working but just today an error poped-up.