Form defaults to filtered record

**bigdgib** · 2010-07-20 12:16

I've just converted to Office 2007. Now when I open a form in my database, it opens to a filtered record. I have to toggle the filter off to access all the records. How can I turn off the default and have the Db open with access to all records?

**AndrewKKWalker** · 2010-07-20 15:15

Have a look at the form in design and just check that there is nothing in filter and that filter on load is set to No

[attachment=89325:FilterOnLoad.jpg]

If it is not that, then check there is nothing happening on the Load or Open Events

**bigdgib** · 2010-07-20 15:31

The "Filter On Load" was set to "Yes." I changed it to "No" and that solved the problem. I wonder why the default was to "Yes" and not "No"? Oh, well... Thank you so much AKW!