Hi,

I am using the following line of code to pass parameters to reports.

dtaEnvSample.Commands("com").CommandText= "select.....

There are 4 command buttons for the different reports on the screen with different SQL statements behind each. My problem is that as soon as I run the first one it seems that every one I run after it is recieving the same SQL code. Is there any way of 'refreshing' the command text ?