Open Report using SQL Query Held in Variable

[MrTBC]

Access 2003
Hi there.
I have a Command Button that generates an SQL Query as a String Variable and then sets this as the Row Source for a List Box.
So far so good.
I then have a second Command Button that Opens a Report. How can I code this second Button so that it passes the SQL Query to the Report and it becomes the Reports Data Source?

Many Thanks.

 

[PHV]

Have a look at the 3rd argument of the DoCmd.OpenReport method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MrTBC]

Thank you. I assume I need to extract the WHERE portion of the SQL query from the end of the word WHERE onwards?

 

[PHV]

You confuse the 3rd and the 4th arguments.
Try this:
DoCmd.OpenReport "yourReportName", acViewPreview, yourGeneratedSQLstring

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MrTBC]

Ah yes, that's working perfectly now.
Thanks very much.