filter works for some, not others

[Guest]

I have a filter in place that sorts by primary key. My main form is linked to
this filtered form - it is set to show me only records pertaining to the
primary key of the main form record that is open. I have noticed that this
filter does not work for some records. The data is still in the table that
supports the form, but my filter is filtering out EVERY record and I get no
results. I can find no rhyme or reason to the records for which the filter
works properly, and those that it doesn't. ??

 

[Guest]

I am not sure what is wrong with your filters but try basing your form off a
query instead. You can use the criteria line to restrict the data in the
query.