Firstly apologies if this is in the wrong place (feel free to move) or has been asked already (maybe I'm searching wrong).
I have a query in Access 2007 that I want to use to generate a report.
Wanting the user to have the option to set stuff like date ranges etc I decided to go down the route to use a form to input the parameters. The help document I followed was:
So I now have a form that I can open - input the data etc.
However when I run the query the parameters asked for (Between [Forms]![MyForm]![StartDate] And [Forms]![MyForm]![EndDate]) come up as popup boxes.
If I have opened the form myself previously and set the data then it runs ok using that data (so is getting input from the form ok).
The problem I have is that I want the form to automatically open whenever that query is run. The tutorial has me create various Macros to enable this but then in the last bit just says about the parameters.
I could of course just add an action to the "Ok" button of the form to run the query then start by displaying the form and that will in turn run the query but I really want the query to open the form for input wherever it is run from - so that any reports using data from the query will run the query which will open the form.
I'm sure it's just some really simple error I am making - I was half expecting to see a macro option or other for the query properties but can't see anything.
I hope that is clear enough; but in summary:
I want a query to open a form to get the parameters which are referenced in the query
Thank you in advance for any help or advice you can provide.