Corrupted Filter by Form?

  • Thread starter Thread starter jculpepper
  • Start date Start date
J

jculpepper

I have recently begun experiencing that records are not
being found with my filter by form. These records have
been recently altered as a rule and can be found in
viewing the table data. They can also be found with a
true query.

Can anyone suggest why the filter by form isn't working
properly?
 
if you are filtering by a text field or memo field you
need to be sure that there are no spaces in your data.

for instance if your searching for "tea" and the data is
stored as "tea ", then the filter passes over it. You can
correct this problem by filtering for "Like 'tea*'"
or "trim(<fieldname>)="tea"

hope this helps

royc
 
-----Original Message-----
if you are filtering by a text field or memo field you
need to be sure that there are no spaces in your data.

for instance if your searching for "tea" and the data is
stored as "tea ", then the filter passes over it. You can
correct this problem by filtering for "Like 'tea*'"
or "trim(<fieldname>)="tea"

hope this helps

royc

Roy,
Click to expand...

Thanks for the update but unfortunatly, this isn't the
problem. If I do a SQL query on the whole name table (the
primary table of use in my data), I get 1299 records. If I
do a Filter by Form, I get 1290 records. There are some
specific names I just can't find by Filter by form. I'm
not totally sure that there isn't some join table problem
and that is messing up the works but I'm also not sure
that I don't have a corrupt Index.

Any ideas?
 
Recently altered. How recently? In the current session of the form?

You might check that your form has its recordset type property set to Dynaset,
vice Dynaset (inconsistent updates). That is sometimes a problem in seeing the
latest data in a group of records.
 
Back
Top