access with 2 combo

I have Combo1 that I have data from access in, and I want when I Click on Combo1 and select somthing I want to display data in the other Combo2 from access.
Now wrong is that it display only one item and not the hole list.
Can wrong be in do until Adodc1.Recordset.EOF that I have for Combo1.

One problem that I have found occasionally is that you need to go to the last record and then the first before you get an accurate record count, i.e.

MyRecSet.MoveLast
MyRecSet.MoveFirst

That should get all of the records.

Cheers

Andrew