Printing MS Access 2007 Report With Different Query Paramenters

[Super Dave 123]

I had created a MS Access 2007 report witch contains a SQL statement for retrieving records from a specific table and using this result to generate a report for printing. How can I use the VB.Net to change the search criteria in the WHERE section of the SQL statement and then have the report to execute the SQL statement with the new search criteria? How can I use VB.Net to get MS Access 2007 to print this report after changing the search criteria?

 

[MattP]

How To Automate Microsoft Access From Visual Basic .NET