Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    22

    Unanswered: How to add a filter?

    Hello,

    How should I do to make a record filtered when I press a command button?
    What I'm after is that I have two forms. The first one is with 4 different product categories and the second one is with ALL products.

    If I for example press the "Product category 1" I want to open the second form with a filter so it only shows the products in "Product category 1".

    Please help me,
    lowtek.

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I assume you know how to set the buttons to open the various forms...then just set the record source to say like ProdCat= "Product Category 1" using SQL or you can set filters on forms by opening the form for category 1, and under the data tab you should see filter. Just type the actual name i.e, fruit.
    Ryan
    My Blog

  3. #3
    Join Date
    Aug 2003
    Posts
    22
    well, I was hoping someone could give me a bit of code that just showed me how to do it.

    I know how to make a button to open the form, I need to put some code there which put a filter on it at the same time.

    (Might be good to get a little bit of code that removed any previous filters aswell)

  4. #4
    Join Date
    Aug 2003
    Posts
    22
    found out there was a wizard in access that helpt me with this. thanks anyway!

Posting Permissions

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