Filter Master Record based on Filter from Child Subform record
Posted on 2012-08-29
I have been racking my brain trying to solve this. OK....
I have a "Main" form = Properties
and each property can have many Tenants so Properties is a split form and Tenants is a subform.
Properties record source is a query = PropertyQuery
Tenants record source is as follows
SELECT AnchorInfo.*, AnchorName & " " & Format([AnchorGLA],"- 0,000") AS AnchorCombo
AnchorInfo is a table containing
PropertyID - this is not a lookUp but is tied to the Properties table via ID
Everything works great...except...now I need to set a filter based on a selection in the subfom that will then filter the Master form. i.e.
Master form Property = City Lake Center
Subform Anchors = Target
I need to set a filter on Target so only the Properties containing Target appear. I guess that would raise another issue because I wouldn't want to filter the subform of any other Anchors.
Should I have a popup filter, Maybe just create a filtered report? Not sure what to do here if setting a text filter of AnchorName woun't work.