Filters Running Amuck

[spherey]

I can't imagine what's caused this, but all of a sudden, all of the forms in this database are showing up as blank. The underlying tables clearly have records in them, and up until recently, these records would show up in the forms, too. Now, they no longer show up. If I right-click on the form and choose 'Remove Filter,' they're back again - but I didn't set up any filters to begin with. Each time I close the form, it's back to hiding the records when I next open it, even if I dutifully click 'remove filter' and save.
There's no filter listed in the form properties (nor should there be), the form is not set to data entry, and I don't know what else to check, as I haven't set up any filters to begin with. Is there something I'm overlooking? What could cause such a thing, and how do I get rid of it? I'd like for the records to be displayed automatically, without the users having to select 'remove filters' each and every time they open the form.

Thanks a lot for any assistance anyone can offer,

Spherey

 

[judgehopkins]

Try this in your form open event procedure. Filters are known to be a tad sticky, but this dumps them from get-go.

Also, if you have a filter command, you might want to also add a show all records command button and add

DoCmd.ShowAllRecords

to that button.

Private Sub Form_Open(Cancel As Integer)
   DoCmd.ShowAllRecords
End Sub

"I have never killed a man, but I have read many obituaries with great pleasure." - Clarence Darrow

 

[spherey]

Thanks Judge!

I figured it out. One of the users had set up a switchboard to open the forms, and chosen 'open in add mode' instead of 'open in edit mode.' So, therefore, when they opened the forms directly, they were fine; but if they used the switchboard form to open any of them, the forms popped up in edit mode. So I changed it back.
Thanks very much, though!
- Spherey