Hello All

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.


Many thanks,
Steve

Hi Steve,



The theory behind a form/subform setup is to filter the subform based on the main form. Although what you are asking is possible, it seems backwards to the purpose of the design. If your main form and subforms are linked properly, as soon as you filter the main form, the subforms will be filtered too.

Could you please explain what you are trying to accomplish? Thanks.