How do I keep the Subform filter property from turning on

[MightyCat]

This doesn't happen on all my other Frm/subfrms that I have. Only this one and I can't figure out whey.

I have a main form with a datasheet subform and a detail subform on it. The detail subform works fine until I filter on the datasheet.

Both forms use the same view.

But, when I filter on the datasheet form, the filter on the bottom of the 2nd subform turns on and I can't unfilter it. I can't figure out what it's trying to filter. If I can figure out how this is happening, I can prevent it and then the subform will just reflect the record selected from the datasheet. This doesn't happen with any other datasheet/detail form that I have.

Does anyone know why this is happening?

 

[MightyCat]

I figured it out. I had a filter on one of the fields in the properties and Even though I had filter on load set to 'No', when I filtered on the datasheet, it set the filter in the property of the detail subform.

I removed the filter in the properties of the detail form and it works fine.