Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Campo, CA, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    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
    Attached Images Attached Images
    Andrew

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Campo, CA, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •