Filtering on subforms

[sal]

I have a form (Table 1 data) with two subforms (related Table 2 data). Each of the subforms are independent views of the same underlying table (different fields). Setting aside the preferred database design issue of why these are not split into separate tables, the fields in one of the subforms is filtered in the subform properties (on load) because it only applies to certain values in the other subform.

This filter works on the data entry loading of the form but when the user goes back to previously entered records the form shows all records, even though the subform's navigation bar shows it as being filtered.

Does anyone have any suggestions on how to maintain this subform filter on all instances of the form view?

 

[sal]

I solved this by adding the filter to the Record Source instead of the Filter Property.