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
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com