Access - Unable to filter on column in table in Datasheet view
When the primary key column in a table contains more than 1,000 possible selections, Access will allow you to filter on it without first filtering on a different column to limit the possible selections.