Using a Criteria Form with an Access Report
Posted on
8,955 Points
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.
0 Comments
Suggested Videos
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database.
Please see the important note at the bottom of this article regarding compati…
