Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter by Form = Is or Isnt Null (A2K 9.0.4402 SR-1)

    After i split a database, I tried the Filter by Form in one of my forms that is based on a query. Before the split, it used to fill up the drop down combo boxes, but now only offers the Is Null, Is Not Null options. The total number of records in the test mdb is 12, and the setting for the Tools | Options | List Display is 1000 records.

    Is this a property of split mdbs? Or perhaps something else?

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter by Form = Is or Isnt Null (A2K 9.0.4402 SR-1)

    Had the same experience. Have yet to find a solution with split DB's. You can still type in values in the filter by form text boxes and use wild cards. That's what I've trained my users to do. One alternative is to build your own filter form. Otherwise, I'd love to know if there is a way to get the drop down lists to work with split DB's.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter by Form = Is or Isnt Null (A2K 9.0.4402 SR-1)

    Something else is going on. I have Access 2000 SR-2 on my machine and don't have any trouble doing a filter by form on a linked table or a query based on a linked table.
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter by Form = Is or Isnt Null (A2K 9.0.4402 SR-1)

    Hmm... i would find it difficult to imagine that the vbe6.dll interference would be causing that. But stranger things have happened.

Posting Permissions

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