Thanks Eric
Basiclly, finding out about rcCommand1 help me solve the problem

>Read http://support.microsoft.com/default.aspx?scid=kb;en-us;244779
>
>
>>Hello
>>
>>I created a report with the command based on table in SQL 2000.
>>
>>The data change many times and we want to use the same report to show the changed data but it is not working it is keeping the first query result. how to fix this problem???
>>
>>would setting the data environment and command to blank then reassign it back will fix this problem?? like VFP grid problem? I will try this in the morning.
>>
>>Thanks
>>Mo