passing value to data report

[tyedyejenn]

I have a VB6 program that runs a report created using the Data Environment and the data report designer. I have an SQL statment in the DE that says:
Select * from Table Where ('Field' = '09/11/2000') this works fine.
Instead of hardcoding the date I want to substitue a variable "strActivityDate". I tried adding "strActivityDate" as a Parameter but couldn't get it. Am I on the right track?

Any Help is GREATLY Appreciated!!! thank you in advance
Jenn [sig][/sig]

 

[DannyB]

Hi those reports can really baffle anyone. If you open the recordset from the connection used by the data environment, you can have much more freedom. After that, refresh the report, and show it modally, and close the recordset afterwards. [sig]<p> Daniel Barreto<br><a href=mailto: Daniel.Barreto@Netc.pt> Daniel.Barreto@Netc.pt</a><br><a href=

http://dba.8m.com>

</a><br>

http://dba.8m.com<br>

http://www.lusosis.pt

[/sig]