<

Using a Criteria Form with an Access Report

Posted on
8,953 Points
2,453 Views
5 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:16
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that appears when the user runs the report.

Video Steps

1. The video provides two examples of reports that load forms on the reports' open events.

2. The code both in the reports and the criteria forms is explained so that the viewer can understand all of the steps involved in capturing report criteria on a form.

5
Author:TechMommy
0 Comments
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user.  I would like to think this is a "le…
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html).  I have realized that my coworkers primarily use Excel and So have changed the ar…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month