I have a form called CRO Summary with a subform called CRO Performance subform. I wish to filter the form based on the value of a field called Analytical Rating in the CRO Performance subform (where Analytical Rating >= 3) .
The form is linked to table called CROList and the subform is linked to a table called CROPerformance. I have a relationship (1 to many) established between ID (primary key) of CROList and ID of CROPerformance.
I wanted to link VB code to a check box, that when checked, would apply this filter.
I have Access 2010.
Any suggestions? Please explain well (give examples), as my understanding of queries and/or subqueries is at the novice level.