Hi,
I am trying to use DataEnvironment1, Connection1 and Command1 with visual basic 6 and produce reports executing SQL commands that use data coming (during run-time) from the user.

A simple example is:
I added a new DataEnvironment1, set the Connection1 and Command1 (using the Properties window) - mean I chose the database (Access) and also, I added a new Report in which I have a text that is bound with the database and also works with the SQL statement of Command1: Select * from ATable where CID = '1'

But in my project, I want '1' to be dynamic, meaning I want the user to write in a textbox (Text1) in a form (Form1) and press a command button (Command1) and this invokes the Report (with : Report.Show )..

Therefore, I want in my SQL statement to join the SQL command with the FORM...
How can I do that???