Hi. I'm using the dynamic query code from MS query samples and am getting a "type mismatch" error. Here's the part of the code that I think is causing the problem -



Q1, Q2, Q3, Q4 are long integers and the Frames are option groups with checkbox values 1, 2, 3 . . .

Leaving all checkboxes blank returns all records as expected, but an error is generated if any box is checked.

What am I missing?

Thanks.

How are you Dim'ing the variable Where? If it's Text, you won't be allowed to set it to NULL - only Variants can be NULL.

You'll probably need to set a breakpoint and step through the code to figure out what's generating the error message.