<

Using a Criteria Form with an Access Report

Posted on
8,667 Points
2,167 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

Featured Post

Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

State of play: Databases ensure data integrity and relationship through both primary and foreign keys, and MS Access is no exception. Well, that's not completely true ... A primary key should not be null.  - No problem, the NOT NULL constrain…
Do you need a date time picker, how about just a time picker?  Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a t…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month