[RESOLVED] Need help with datareport / dataenvironment

[Vovo]

Hi everyone,

I have a form that displays customers, in a combobox. You select one and click a command button.

it then generates another combobox with the month usage reports. you select a month to view and click a command button.

This brings up the datareport with the data for that time period.

This all works.

if you then select another month and click the command button it will display the same info again.
I have used debug.print, gotta love it, and it shows that the sql is different. But the report is still the same. this is how i change the command text.

DataEnvironment1.Commands.Item("Command2").CommandText = strsql
    DataEnvironment1.Commands.Item("Command2").Execute strsql

why doesn't it work.