Subform filter applying to wrong field

[Jobadiah]

I have a subform with a datasheet view. When I attempt to use the column filters on the "Student" field, it is applying the filter to the wrong field.



For example, if I select the filter for "Student" and choose Text filter->Contains"->Test1, it should filter to show me all records with "Test1" as part of the student name.


Instead, it returns nothing and on further inspection it has applied the filter to the grade (stu_level_code).




I do not have any code attached to any events on the "Student" field, so I have no idea why this is happening or how to begin troubleshooting it. Any advice would be appreciated.

[Welshgasman]

You are not showing a clear picture.?

Your first shows filter on Student, yet the second shows it is filtered on grad?

When I try and filter I am shown all the distinct entries as well?

[Gicu]

Check if the subform or its record source have a filter saved. Is there any code behind the subform or the main form that might impact this (not only the Student "field")?
I see your table is linked form SQL server, does it have a primary key?
Cheers,

[Jobadiah]

Well, it turns out the issue was with some bad data that was causing an error in a view that was being used as the record source.