What is the best way to print a Recordset?

[ChampionDuy]

I have a recordset that displays in a list box and I need that recordset to be printed. What is the best way to go about this?

 

[Travis]

I would go with a report. This is the easiest method for printing. You can create the report off of the same recordset that the listbox is using.

 

[ChampionDuy]

Any examples on the code for that. I struggled through creating the recordset and I could use some good examples of code for printing a recordset to a report. I tried a OutPutTo command but that didnt seem to work. Any help would be greatly appreciated.

 

[Travis]

Is your recordset based off of a Query? or an SQL Statement?

 

[ChampionDuy]

It is based of off a SQL statement.

 

[Pat Hartman]

Use the query as the recordsource for a report.

 

[ChampionDuy]

I use the sql statement as the recordsource for the report but the report does not show any data. This is the code that I have producing the report.

DoCmd.Echo False
DoCmd.OpenReport "QryResults", acViewDesign
With Reports("QryResults")
.Visible = False
.RecordSource = lsSQL
End With

DoCmd.OpenReport "QryResults", acViewPreview
DoCmd.Echo True

Where lsSQL is the SQL statement that the user enters. When I look at the properties of the report, the record source does show my sql statement. I dont understand why nothing is showing up on the report. I do a debug.print of my query and it produces the query results in the immediate window. I have to be making a stupid mistake somewhere. Thanks again

 

[Travis]

Brain,

Have you bound the Report Fields to the Fields of the Recordset?

 

[ChampionDuy]

no I have not done that, How would I go about doing that since the user enters the query and the fields change every time a user enters a new query.

 

[Travis]

You have just added an other wrinkle that you did not mention earlier. You want an AdHoc Type Report, with custom Columns.

You need to look at using the Docmd.TransferText function.