Trouble with VB coding...HELP PLEASE

I have an Access 2000 database serving as a front end to MySQL. In that Access database, I've created a pass-thru query, and a little bit of VB code to create the SQL statement dynamically. I can't figure out how to use VB to put the SQL code into the pass-thru query. What I need to do is something like this:

Set PassThruQuery.SQL=SQL

But I can't figure out the syntax to do it! Once I do that, I'll be able to issue an open report command for a report that uses that query for its results. There has to be a way to set the SQL property, but I just don't know how to do it. Any ideas?

Thanks!

Try looking here: <http://visualbasicforum.com/>

thanks, didn't know that site existed. i had looked everywhere. usually go to devshed.com first!

No problem -- I didn't know it existed either, until I searched for it on <http://www.google.com/>. That's usually the first place I go.