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.

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

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

Kenny Alligood

Thanks for the suggestion Kenny. I have read everything and it looks like it just might work pretty well. I am going to give it a try and let you know how it went.

Thanks and Best Regards,
Donrafeal