Hi,
I want to be able to create a form in VB6 to setup an SQL statement which users can use to search for records by certain fields if they need to. I know how to do this, but what I don't know how to do is open an existing MS Access report and populate the row source of that report with the sql statement so I can print or preview the report. I know how to do this from an MS Access form but not from a VB6 form. Any help would be greatly appreciated.

In case anyone is interested I received help from the Pro VB Databases forum. That person suggested the following:

--------------------------------------------------------------------------------

Look at this post and it may answer your questions...

http://p2p.wrox.com/topic.asp?TOPIC_...Access+report+

Kenny Alligood