Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    63

    Unanswered: Filtering Comb box based on user selection

    I'm creating database to keep track of documentation. For this database i have tblStudy, tblSite and tblDoc. Based on the tblStudy and tblDoc i created frmMain. On the top of the form user select from the combo box if the documentation is for "Reg" or "Site".

    Now when user select from combo box "Reg" combo box "cboStudy" becomes visible where they can select the Study.

    Now when user select from combo box "Site" combo box "cboSite" becomes visible where user will first select the Site and then "cboStudy" will be visible where user can select Study for that site.

    Now my question is that how can i filter out "cboStudy" when user have selected "site" but i don't want to filter out "cboStudy" if user selects "Reg"

    I hope this is clear of what i'm asking if not i can post sample db

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I am not sure I understand. I will give it a shot here...

    You are wanting that top combo box to control ('filter') what the user sees? When you press the cboSite you want it to hide ('filter') the cboStudy and the same visa versa?

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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