Morning.
I'm not sure whats going on here, but i have a form set as a dialog box with a date picker. On the "On Change" event, i open a report that uses a query, where the date criteria is set to the form date field, so that all a user sees is a date selection then it should auto open the report with results.
Its opening the report but with no results. I can run the query separate and it works fine.
Any ideas on what to check?