Passing Variable to Report

[TomEDeadman]

Hi All,

I am creating an application that ties into an Access database but I am having difficulty with the reporting feature in VB6. How can I pass a variable from a form into the SQL statement in a Data Environment? As an option I can create various commands linked to Queries within the database but I would still need to pass variables from a form into the query.

Any help or suggestions would be appreciated.

Try to keep it in plain english I am a Network Engineer not a programmer.

Thanks,
Tom

 

[johnwm]

mySQL = "SELECT thisfield, thatfield from tblWhatever WHERE namefield = " & txtName.text Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'