Search results

Hi Wayne, By setting conditions within the query the user has to choose both conditions straight away. What I am trying to achieve is a filter within a filter. The user chooses the first filter option, gets the information they require and then narrows down the field by running another filter...

Hi Wayne, Thanks it does work. I appreciate your help. However...... By setting conditions in the query I have restricted the user. What I was ideally hoping to do was when the user chooses an item in the combo box to filter the subform they should then be able to filter within those results...

Hi Flyer, How do you reference the combo boxes in the query? Cheers Jill

I looked through 7 pages worth before writing this question. Many of the questions wanted to restrict the actual data in each combo box based on the choice picked from the first combo box. All I want to do is have the data on the subform filtered based on 2 combo boxes. eg: Combo1 = tblPosition...

I have a form where the user can choose from 4 combo boxes to Filter the data appearing on a subform. At the moment only one combo box can be used to filter at a time. How can I get the data filtered by 2 or more combo boxes? Cheers Jill