Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing parameters to Data Environment

Status
Not open for further replies.

wild007

Programmer
Sep 27, 2000
36
US
I have a menu on a form in VB6. When I click on the report name in the menu, I would like to open a report based on the record's primary key that I'm currently viewing. I am using the Data Environment. How do I go about passing that parameter to the query? I am new to VB, so any and all help is appreciated. Thanks in advance.
 
try something like this:

in the SQLstring you make your query, using the parameter as a variable.



DataEnvironment1.Commands.Item(1).CommandText = SQLString


i hope it helps

Eli
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top