Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to base a report on a non-persistent recordset 1

Status
Not open for further replies.

GSMike

Programmer
Feb 7, 2001
143
US
Does anyone know how to create a recordset through code, and then base a report on that recordset?
The reason I need to do it this way is because I am reporting on the data structure of tables, i.e. reporting on the fields in the selected tables.
Of course, I could use the Tools>Analyze>Documenter utility, but that doesn't include "Description" comments, which are critical in this case.
Thanks for your help.
Mike Kemp
 
If you already have your recordset built and open, just use:
Forms(FormName).RecordSource = rst.SQL

Otherwise, you can build your SQL as a string and assign it to the form's RecordSource property. Rick Sprague
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top