Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Ohio
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filter by form malfunction (2002)

    Suddenly my filter by form seems not to work. Could I accidentally turned off a switch. It has been working marvelously. just clicked on filte by form on toolbar typed in data in a field and bingo got the record. It even auto filled once i started typing. Now it returns blank record, does not auto fill and show a scroll indicating null or not null. What did I do and how to i get the feature back?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: filter by form malfunction (2002)

    Check the Edit/Search tab of the Tools | Options... dialog. there are check boxes to specify whether the form filter should display lists in local indexed fields, local non-indexed fields and fields in linked tables. You can also set a limit on the number of unique values above which a list is no longer displayed. These are per-database settings.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Ohio
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filter by form malfunction (2002)

    Thanks. My data base has 1043 items and the default limit was set at 1000. Changed it to 5000 and all is working well.

Posting Permissions

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