Why, in this case? I don't think either suggestion has been implemented yet, so there's no code to check, and as of yet, no error to look for.You could always put in breakpoints in the code
F9 where your cursor is, then step through
Re post 11, Date() is required in sql; Date in vba.
Although not really the same, people get confused over IsNull in vba, Is Null in sql as well. IsNull is a function. Is is an operator checking for Null.