Filter a subform on load in Access 2010 based on a calculated field
Posted on 2011-09-06
Experts...I've tried so many different ways and researched how to accomplish this and to no avail...I am at a stand still and the veins are popping out of my neck!
The calculated field in my subform is simply FieldA - FieldB = MyCalculatedField.
When the form opens with its subform, I would like the subform to only show records where the MyCalculatedField are greater than 0.
Please help! Simple, easy to follow instructions would be greatly appreciated!