I want to call an Access report from Visual Basic. In the VB app, the user decides what parameters to be set when the report is run (eg. 'Name' = 'Bob' or 'City' = 'Chicago'). After the user selects the desired options, the code generates the SQL statement.
I've read the posts about how to call the report from VB, and understand how to do that. The problem is that the report's underlying query can change (sometimes they select Name, sometimes City, etc.), since the user has different options to select. Therefore, I can't have the report call the same static query each time.
Is there a way to pass the SQL statement from VB to Access?
Thank you,
Steve Geller
I've read the posts about how to call the report from VB, and understand how to do that. The problem is that the report's underlying query can change (sometimes they select Name, sometimes City, etc.), since the user has different options to select. Therefore, I can't have the report call the same static query each time.
Is there a way to pass the SQL statement from VB to Access?
Thank you,
Steve Geller