If you hardcode values first does it work?

It looks to me like you need to apply parentheses so that the clause is appropriately applied correctly.
If for no other reason than readability.

There are a lot of ANDs and ORs. I would use parentheses.

Perhaps something like this:

" ~ WHERE (Telesales = forms![figuresF]![combo_FilterTelesales]" & _
" OR Chaser = forms![figuresF]![combo_FilterTelesales])" & _
" AND (FilterYearAppt = Forms![FiguresF]![Combo_FilterYear] " & _
" OR FilterYearChase = Forms![FiguresF]![Combo_FilterYear])" & _
" AND (FilterMonthAppt = Forms![FiguresF]![Combo_FilterMonth]" & _
" OR FilterMonthChase = Forms![FiguresF]![Combo_FilterMonth]);"

Note: I haven't tested this in Access so may need tweaking.

Thanks guys. Kevins method worked BUT i went and added a third part and that third part doesn't work - it isn't filtering essentially.

I'm 99.9% there and it looks amazing. The form is dcounting 7 "types" of records, then looking up the multiplication factor and calculating accordingly. Just one of the  factors isn't quite working. FYI, it's a list box which alters its columns based on buttons on screen.

I've separated the sections for easy readability and the bold one is the one i'm having problems with (The one i added after your post)

    RS = RS & " FROM FiguresQ WHERE (Telesales = Forms![FiguresF]![Combo_FilterTelesales]" & _
                        " OR Chaser = Forms![FiguresF]![Combo_FilterTelesales])" & _
                        " AND (FilterYearAppt = Forms![FiguresF]![Combo_FilterYear] " & _
                        " OR FilterYearChase = Forms![FiguresF]![Combo_FilterYear]" & _
                        " OR FilterYearLOA = Forms![FiguresF]![Combo_FilterYear])" & _
                        " AND (FilterMonthAppt = Forms![FiguresF]![Combo_FilterMonth]" & _
                        " OR FilterMonthChase = Forms![FiguresF]![Combo_FilterMonth]" & _
                        " OR FilterMonthLOA = Forms![FiguresF]![Combo_FilterMonth]);"

Its end of the day for me and i don't work Friday (And we brits get the Monday off to coronate our king) so i'll take a look with fresh eyes next week.

Really appreciate the help. I'll be sure to show off with screenshots when i'm done :)

Hi Dan, the parts of your criteria that have multiple Or conditions will evaluate to True if *any* of the Or conditions is true.  For instance, all the expressions below produce the same result, True:

     True And (False Or False Or True)
     True And (False Or True Or False)
     True And (True Or False Or False)
     True And (False Or True Or True)

None of the above Or conditions would be what I would call "decisive" -- meaning, whether they are true or not won't matter, as long as one of the other Or conditions is true.  If you want a condition to be "decisive", it needs to be an And condition.

For instance:

     A And (B And (C Or D))

In this case, both A and B are "decisive" -- if A is false, the whole expression is false; if B is false, the whole expression is false.