Data Report not refreshing

Hi
I am using data report with the data environment in my program
When I show the report for the first time it works OK
If I now show the report again, any new data in the database is not shown in the report.
If I stop the program and restart the report shows the updated data.
How can I getr the report to show updated data without stopping the program.
I have tried refreshing the datareport
I have closed the data environment connection but when I open it I get an error message:

Invalid SQL Statement:
Expected DELETE;,INSERT;,PROCEDURE;,SELECT; or UPDATE

Any help please

Hello

Try this:

Code:

---

'Tthis line is a way of allowing the report to be refreshed with new data.
'Otherwise, old data will reappear even if the report is first closed and reopened.
If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close

---

Hope this is what you are looking for

Steve