Automatically Return Parameter Query as a Report

[mestst64]

I created a combo box that runs a parameter query based on the name entered in the box.

Is there some way to return the results as a report instead of in datasheet view?

I'm wondering if inserting some sort of code into the event procedure of the "OK" button (which launches the query) would work.

Would greatly appreciate help---

 

[clerics]

If you want to view report like "SQL code" ,
use this code -->

Dim rs As DAO.QueryDef
Set rs = CurrentDb.QueryDefs(Me.RecordSource) ' Me.RecordSource 's just an example. It depends on you !
Me.SQLview = rs.SQL
Set rs = Nothing

Is this what you want to try, friend ?

 

[Smart]

Create a report based on your query then in the onclick event of your ok button replace the code that calls the query calling the report instead

 

[mestst64]

Thanks Smart!!! This generated a report just like I had hoped! However, instead of displaying it on the screen, it sent it directly to the printer. Any advice on how it can be previewed first; with the option to then print it or close it?

Thanks again for bringing it this far---

 

[mestst64]

Got it figured out (with help )

DoCmd.OpenReport "MyReportName", A_PREVIEW