Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Location
    UK
    Posts
    160

    Unanswered: trouble filtering data

    Hi again,

    I'm using a list box to display categories. I reference the list box in a query in the criteria section under category. So i have a subform with all the parts which i can filter depending on the category a select in the main form.

    tbl_Parts
    Category
    criteria
    [Forms]![main]![cboCategorySelection]

    I|t filters the results fine. However, I am trying to remove the filter so all records are shown. I have tried numerous options like putting a "*" in the category list thinking it would feed that into the query but it came up blank.

    Is there a way to ignore the category criteria and show all the parts?

    Many thanks

    Marcus

  2. #2
    Join Date
    Sep 2010
    Location
    UK
    Posts
    160
    sorted. Found answer in forum. thanks

  3. #3
    Join Date
    Sep 2010
    Posts
    10
    Could you post a link to the thread that helped you fix it? I'm assuming it was discovered that you cannot remove part of a filter, but must remove the whole filter or recreate it without the component you were trying to leave out?

Posting Permissions

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