Access 2010 Data Range Form Used for Multiple Reports

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!
Screenshot.jpg
Senniger1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
Your approach is as good as any, in my opinion. You could always reverse the process, and use the Open event of the Report to look for that form and, if it's open, use the Dates found there for filtering.

See more on the Report.Open event here: https://msdn.microsoft.com/en-us/library/office/ff834749.aspx?f=255&MSPPError=-2147217396

As far as users affecting each other - each user should have their own standalone copy of the Frontend, so their filtering would have no impact on other users. If you have users sharing the same copy of the FE, then you have much bigger issues coming down the road.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.