In Access 2010 I have a form which has unbound text boxes for the Start Date and End date (see screenshot).
The idea is my user will enter these dates and when they click the OK button; it'll filter the report they're going to run.
Here is my issue... I don't want to have to create a form like this for every report which needs a date range. I'm thinking I should be able to call this form for all my reports; I just don't know the best way to accomplish this.
I wrote code for the OK command button which says "if it's REPORTA then run this report" and "if it's REPORTB then run this report" and "if it's REPORTC then run this report", etc. and this seems to work fine.
I'm just not certain this is the correct approach and also I'm concerned what if multiple users are in the database and running the same reports with different criteria. Will they be affecting each other?
Thanks in advance!