Microsoft Access Tips
Tips and Information for people wanting to explore the Microsoft Access Database.
Friday, 30 September 2011
Filtering Report Results Using the Filter Property
In this tip we are going to filter the results of a Report to display records with order amounts above a given value. In so doing we are going to pay special attention to two Report properties: these are FILTER, and FILTER ON LOAD.
Our solution works when the user opens a Dialog Form containing a text box and command button. The user enters an amount value in the text box, and clicks the command button. The command button then runs a small amount of VBA code to open the report. As the report loads, it applies a filter defined in the Report’s Filter Property to produce the desired result.
|Continue reading “statistics brain school uniforms”|