Printable View
Okay, I would like to know if anyone has successfully been able to pass a parameter from a form in VB6 to a Data Environment in order to create a Data Report. Basically, I have done everything to create the report. It looks GREAT! But now I want to be able to pull this report based on a set of dates. >StartDate and <EndDate. Can this be done?!?!?!
I don't know about the data reports but this is what i used for a datagrid based on a dataenvironment parameter query
With DE1
If .rsqryPlatingRecords.State = adStateOpen Then
.rsqryPlatingRecords.Close
End If
.qryPlatingRecords txtFields(1) '*SEE BELOW
Set DataGrid1.DataSource = .rsqryPlatingRecords
End With
*'qryPlatingRecords is my parameter query - txtFields(1) is the parameter off the form used for the query