When I switch to SQL code and have the correct syntax (which I didn't in the post I deleted), I do not get an error. Is Null is for queries; IsNull is a vba function. Try Is Null instead.