<

Using a Criteria Form with an Access Report

Posted on
8,338 Points
1,838 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
Comment
Author:TechMommy
0 Comments

Featured Post

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month