Opening recordsets for viewing

[fredfortsonsr]

I use the following code to define a recordset:

Set RstDewPoint = WorkDB.OpenRecordset("SELECT * FROM qryFindDewPoint ORDER BY [Zero Deg Point]", dbOpenDynaset)

I am not getting any errors. However, after looking for a way to open the recordset so I can view the records within, I am still at a loss.

Is it possible to open a recordset to verify that the command worked as expected?

Thanks

Fred

 

[joeyreyma]

you can copy the SQL of your recordset, then create a new query, goto SQL view and paste the copied SQL. then goto Datasheet view of the query. it will display the output.

 

[fredfortsonsr]

Actually, I did just the oppisite. I created the SQL first and that's how I got the proper syntax for the recordset. However, when I run the VB code I would like to do something that is the equivalent of Debug. Print to view the results as the code runs. The reason I think there may be a problem is because I have a Debug.Print command a few lines after the recordset statement and I attempt to print a value from a couple of the fields. Nothing prints, so I am thinking it's a problem with the recordset.