Hi,
My database has some queries and reports which I want retrieved by selecting a button on a form.
I want the user to select a query, and a form will pop up to request which date they would like (this form contains comboboxes and listboxes to ensure valid entries). The user can select their criteria, and this will feed a table (tbl_date). I've done the above, this was fine, but the next step is proving difficult:
1. open form to select date
2. select date
3. close form
4. open report (which is the result of a query using tbl_date)
I've tried writing a macro to do these steps, but they all occur at once. I want to be able to select the date, and then press a button to open a report.
The form for selecting a date is used in more than one query, so I don't want to create loads of identical forms with buttons to do different things.
Please help on how I can do this?
I hope this is not confusing, please let me know if you would like more detail.
Thanks
Phonic
My database has some queries and reports which I want retrieved by selecting a button on a form.
I want the user to select a query, and a form will pop up to request which date they would like (this form contains comboboxes and listboxes to ensure valid entries). The user can select their criteria, and this will feed a table (tbl_date). I've done the above, this was fine, but the next step is proving difficult:
1. open form to select date
2. select date
3. close form
4. open report (which is the result of a query using tbl_date)
I've tried writing a macro to do these steps, but they all occur at once. I want to be able to select the date, and then press a button to open a report.
The form for selecting a date is used in more than one query, so I don't want to create loads of identical forms with buttons to do different things.
Please help on how I can do this?
I hope this is not confusing, please let me know if you would like more detail.
Thanks
Phonic