There are several ways of applying a filter to a report. In the following video I demonstrate a method I use...
Filter a Report from a Form - Nifty Access
On my website here, I demonstrate a way to create filters easily:-
Filtering - MS Access Forms This video should be of interest to anyone who wants to easily apply filters to an MS Access form in datasheet view or continuous form view. In this demonstration I show how you can apply filters in a Form presented in Continuous view and also in Datasheet view. When you
www.niftyaccess.com
In the above video I demonstrate some code for checking a combo box is not empty. I realised that this single line of code evolved from multiple lines of code. I thought "That's a good example for someone new to creating functions". In particular this function shows how you can pass an object into a function, process it, and return a Boolean Value, telling your code the process was successful (or not). The following YouTube Video demonstrates the evolution of the code, some of the hiccups and problems, and finally the solution!
Writing Your First Object Function - Nifty Access
UPDATE!!!
I wasn't happy with the previous video because I didn't cover how it checks the combo boxes very well. I still don't think I've quite got it right, anybody want to chime in with any tips how I can improve my presentation I'd be most grateful!
Writing Your First Object Function - Extra - Nifty Access