Thanks for your reply George, I found a lot of stuff on that site very informative. I didnt really understand the INNER JOIN stuff though, as I am only really working with one datasheet at the moment I didnt think it was necessary. The code that seems to work now is:
Private Sub filtering()...