Hi,
I'm currently using the Data Report facility of VB6 and am quite new to it.
Wondering how I can set the commandText of the command facility under the dataenvironment with variables I have passed into the report?

My commandText string of the command is like this:
SELECT * FROM tblcustomersection where RequestNo > '" & requestNoStart & "' and RequestNo < '" & requestNoEnd & "' order by RequestNo

requestNoStart and requestNoEnd are variables I've passed into the generated report but unfortunatley these don't seem to be picked up by the commandText.
Hope I'm doing something basic wrong.
Thanks.