<

Watch Using a Criteria Form with an Access Report

Posted on
8,740 Points
2,240 Views
5 Endorsements
Last Modified:
Experience Level: Beginner
5:18
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
Generating sequential numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more. Here we will show how to accomplish this in several ways with either little or no code.
A small utility that imports the tables from Older - Unsupported Microsoft Access Databases

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month