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