Re: parameters for a report
Try the following:
modify the commandtext property of the command object at runtime
eg
Dataenvironment is dataenvironment1
connection is connection1
command is command1
try the following code
dataenvironment1.commands("command1").commandtext = strsql
dataenvironment1.rscommand1.open
where rscommand1 is the recordset object of the command and
strsql = the SQL statement containing the parameters
eg Strsql = "select * from categories where categoryID = " & text1.text & "
Hope this will solve your problem
Regards,