Can someone tell me what I am missing here please?
Why does this work?
and this doesn't?
I get a "Type Mismatch" error.
Thanks, I always have trouble with multiple criteria.
Why does this work?
Code:
pubSwitchRequestID = DLookup("swrSwitchRequestID", "tblSwitchReport", "swrComplete = False")
pubSwitchRequestID = DLookup("swrSwitchRequestID", "tblSwitchReport", "swrCanceled = False")
and this doesn't?
Code:
pubSwitchRequestID = DLookup("swrSwitchRequestID", "tblSwitchReport", "swrComplete = False" And "swrCanceled = False")
I get a "Type Mismatch" error.
Thanks, I always have trouble with multiple criteria.