Populate Combobox with Distinct data from specific access table field

Hi all,

i'm nearly there!

i just need some tweaking, i have a userform which is populated with data from an access database.

basically i want to select a fileds in a combox (CBFilter1) and then populate all the distinct values from that field in another (CBCriteria1).

here is what i have to far:

Please Login or Register  to view this content.

i reckon it's something to do with the bit at the bottom where it's putting in the rs.fields etc i assume it should be row related as this is wher the records will be?

any help is really apprectiated

thanks

Solved it:

http://www.fontstuff.com/vba/vbatut10.htm