filtering with combo boxes
 

I want to be able to filter up to 10 columns of data by using combo
boxes for each choice. i.e. box 1 can select from column 1 etc... as
the amount of data increases in each subsequent column i need to be
able to resrict the available choices for box 2 to only those which
match with the output from box 1 etc.. this is a way of replicating
what can be done with autofilter.
i have seen the end results done using combo boxes in access but i
cannot see the background info, nor can i use access yet. i can
normally fumble around in excel though.

Any help gratefully received,
Hagar