I created a filter on a subform, but the filter didn't have any effect on the main form. Why not?
The filter behaved correctly. When you create a filter on a subform, it only applies to the subform. To filter the records on the main form, click the main form, and then create the filter.