Stuck filter anyone else have this problem

[Gina Maylone]

Several times lately, when a form, report or query isn't displaying correct information or is prompting me for some random criteria, and if I look in the properties, I will find for example [members].[memberID_PK]=61. Of course I can't find a live example at the moment, but this is where it appears. Where is this stuck??



Thank you in advance!! ~PEACE~

[ranman256]

the filter should have no affect on the query unless you apply it.
if you are prompted where you have none, then either:
..you have criteria it cant find
..a field is misspelled

if in a report,
check the GROUPs , sometimes a field will be missing , and the group cant find it.

[Gina Maylone]

Here is an actual example of what I'm talking about. I haven't looked up member 1499 in hours! And no, it is not currently affecting my form, but it has before.