Query & Coding issue

I have the coding below in VB. I have a user form that allows the user to select a date range & an Open or Closed status or both. If you select a date range one of the status selections the query only looks at the status you selected & brings up everything for that status. If you open the query back up after you run the code in design mode it is blank except for the status you selected on the form. I can't figure out what's missing.

Please Login or Register  to view this content.

Have you also tried running the generated SQL outside VBA?
If there is a problem with the SQL, sometimes you see that.

Have you tried deleting your current query, than using CreateQueryDef to recreate it?

Hi
Can you please upload database

Regards