hi i have a data report in vb6 that is attached to a data environment, but i have a problem with my query.. my query will consist of a where clause for example: WHERE date = '" & form1.label1.caption & "'"

but currently i put my query at the properties window of the data environment, is there a way to be able to write the code of the query on the form itself? i tried using dataenvironemnt1.command.commandtext but there isnt any