Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Filter by form and linked tables

Discussion in 'Information Technology' started by Ben, Oct 29, 2005.

  1. Ben

    Ben
    Expand Collapse
    Guest

    Does anybody know why I get valuees of 'is null' and 'is not null' as my
    filter criteria in filter by form mode when the data comes from linked
    tables? I increased the number in the 'don't display when...' field under
    tools-options but I am still getting this result. Tests with ordinary tables
    did not have this result. Cheers.
     
  2. Loading...


  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Ben.

    > Does anybody know why I get valuees of 'is null' and 'is not null' as my
    > filter criteria in filter by form mode when the data comes from linked
    > tables?


    This is the default for linked tables. Local tables will show the items on
    the list, unless they exceed the number set in the "Don't display when . . ."
    option, or the option is turned off for local tables.

    > I increased the number in the 'don't display when...' field under
    > tools-options but I am still getting this result.


    In addition to this step, open the form in Design View and select a text box
    that is bound to a field in the linked table, then open the Properties dialog
    window. Select the "Data" tab and then select the Filter Lookup Property and
    change "Database Default" to "Always."

    Do this for any other text box that needs a list shown instead of "NULL" and
    "Is Not NULL" in the combo box when Filter-by-form is being used. When
    finished, close the Properties dialog window and save the form.

    Open the form in Form View. Select the "Filter-by-form" button on the
    built-in toolbar and then select one of the text boxes that you changed.
    You'll see the entire list, not just the "NULL" and "Is Not NULL" in the
    combo box.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips.

    (Please remove ZERO_SPAM from my reply E-mail address so that a message will
    be forwarded to me.)
    - - -
    If my answer has helped you, please sign in and answer yes to the question
    "Did this post answer your question?" at the bottom of the message, which
    adds your question and the answers to the database of answers. Remember that
    questions answered the quickest are often from those who have a history of
    rewarding the contributors who have taken the time to answer questions
    correctly.


    "Ben" wrote:

    > Does anybody know why I get valuees of 'is null' and 'is not null' as my
    > filter criteria in filter by form mode when the data comes from linked
    > tables? I increased the number in the 'don't display when...' field under
    > tools-options but I am still getting this result. Tests with ordinary tables
    > did not have this result. Cheers.
     

Share This Page