Troubleshoot filters in tables, queries, and forms

What do you need help with?

The filter didn't return the correct records. Why not?

The filter didn't sort the records in the correct order. Why not?

I can't use an existing query as a filter. Why not?

Why are some of the fields in the Filter By Form window unavailable?

Why do the lists in the Filter By Form window take so long to display?

I don't have lists of values to pick from on one or more of the fields in the Filter By Form window. Why not?

I created a filter on a subform in which the records were synchronized with the main form, but the filter didn't have any affect on the main form. Why not?

I created a filter on a subdatasheet, but the filter didn't have any effect on the datasheet that displays the subdatasheet.