I suggest you do away with the nested double quoting and use singles instead. Easier to follow. Your " and " looks like it is out of place. Same with your =#"
Also, if this is vba, IsNull is for sql. Is Null is for vba.
EDIT - and it's = False, not .False
You also have # date delimiters on the wrong side of the =.
Last edited by Micron; 04-20-2020 at 09:50 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.