Data Environment - HELP!

[hyme]

Howdy!

Is it possible to create a Data Environment through code and then connect a data report to it? If so, How?

Because,I have a Data environment with a report connected to it.
But, I need to change the SQL statement in the Data environment during run-time! - That is my goal!


Thanx


[Edited by hyme on 08-01-2000 at 09:31 AM]

[hyme]

I can change the Data Environment like this:

DE.Commands("cmFormu").CommandText = "Select * from Client ORDER BY Index"

But, how to you update the text fields on a Data Report
attached to it?

I get the error

"datafield "cmFormu.Client.Index not found"

[Nathan]

I'm not completely sure what you are trying to do but... you could take a look at a microsoft article "HOWTO: Dynamically Populate a Data Report in Visual Basic" at http://support.microsoft.com/support.../Q240/0/19.ASP

[hyme]

Thanx a million
It's exactly what I was looking for!