Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Multiple filters on a form

    I would like a form that has 3 -5 combo boxes on the top portion, these would be

    Fund, portfolio, Investor, Contact Type

    When i select a fund the availible portfolios in that fund populate the portfolio cbo

    After a fund and portfolio are selected the Investor cbo populates
    and a datasheet below fills with all the contacts for that investor in that fund and for that portfolio

    finally when the contact type cbo changes it filters the Datasheet for only those type of contacts in that fund, portfolio for that investor

    is this possible with out vba???


    tks ~M

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    It will be a very tall order with NO vba. You can append additional criteria to the filter property using 'AND' & 'OR'.

    You won't need very much vba to get it done, but I'll be fairly surprised if you can pull it off with none at all...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Oct 2003
    Posts
    311
    can u give me an idea of the vba?, i use vb.net so i can pick it up quick

Posting Permissions

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