Records are automatically being filtered

[thowe]

All of the sudden, I go to open one of my forms and it has completely filtered out all my records. I can click on "remove filter" and all is fine, but as soon as I close and open the form again, the filter has appeared again, even after saving. I don't know how this filter appeared in the first place. There is no "on open" event applied, and no text in the filter area of properties on the form. The form is based off of a query, the query works fine. Can anyone help? I am using Access 97, and am not a programmer.

 

[Aivars]

Hi!
Look at form open procedure. Maybe you open form by Where contition(LinkCriteria):

docmd.OpenForm "MyForm", , , stLinkCriteria

If you want to open form without filter you may write:
docmd.OpenForm "MyForm"

Aivars

 

[thowe]

Wow, with a little playing around with it, that worked! Thank you! I have no idea how that filter appeared in the first place!!!!!!!

THANKS!

 

[thowe]

Just found another problem. ALL of forms are based on Queries, so shouldn't the form just open what the query says should be opened? It isn't working this way and I don't know why! Any great inspirations out there?