Hello vb-world fans !

I am moving slowly through ADO and I ran to a problem I already had once but @ that time I didn't care about it and did a workaround. But now I want to solve it. Soooo ....

I have a combo -> User selects a record -> BoundText returns ID and I want to display the respective records in another combo. Doesn't look hard, does it? /Let's use a simple example: In one combo you have all surnames and when you select for example Moore it will populate the other combo with Karl, Peter, Josh etc./

I have created a command that selects the records from the table and I thought that when I just add the WHERE clause to the commandtext at run-time it will work. But oh ah ...
When I set the command text to the new value "SELECT ... WHERE ..." nothing happens and combo stays empty. Even after changing the commandtext I rebind the combo -> no change.

So ... looks simple to me but I can't figure it out.
Anybody?
TIA.