DataCombo & DataEnvironment Refresh

[Jaime Herrero]

Hi everyone

I´m in trouble with DataCombo an DE.

I have a DataCombo with a RowSource established to a DataEnvironment Command Recordset (cmcountry-->rscmcountry)
I try to change this Command recordset as follows

rscmcountry.Close
rscmcountry.Source= <...FILTERED SQL STATEMENT...>
rscmcountry.Open
DataCOmbo3.Refresh (I also tried DataCombo3.REfill)

I can see in the Debugger that rscmcountry has the correct values, but the combo doesn´t refresh
at all... the combo´s visible items after refilling is 0! :(

I tried to bound the Combo directly to the Command
(RowSource=cmCountry), but when i change the command Source to fiulter the register, the
rscmcountry sourvce didn´t change with its command source, and the contents of the combo are
the same as the original command´s source :(

At last, i´ve tried to declare an ADODB.REcordset,
execute the command

Set rsCountries= cmCountry.Execute
But when i bound rsCountries to my combo, it´s not
filled.

The only way i get the correct results is using
an ADODC, but i think thatevery ADODC consums a
different connection, and when i have more combos,
I will be spending many resources.

Can you help me? Please answer if you know the answer or can send me a related code.