Seeing a recordset

[Iainkerr01]

How can I display the results of a Recordset?

 

[dhookom]

This is straight from Help:

The following example opens a form, opens a recordset, and then binds the form to the recordset by setting the form's Recordset property to the newly created Recordset object.

Global rstSuppliers As ADODB.Recordset
Sub MakeRW()
DoCmd.OpenForm "Suppliers"
Set rstSuppliers = New ADODB.Recordset
rstSuppliers.CursorLocation = adUseClient
rstSuppliers.Open "Select * From Suppliers", _
CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Set Forms("Suppliers").Recordset = rstSuppliers
End Sub

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Iainkerr01]

Does it matter if I'm using DAO rather that ADODB?

 

[dhookom]

Did you check Help like I did? Can you explain why you need to see a recordset?

You can actually write a little code that loops through the records and fields and displays the results in the debug window.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Iainkerr01]

I want to optionally display the results in "notepad" following a query so that the user can see exactly the results of the query prior to sending emails.

 

[dhookom]

I would create a query with the recordset's SQL and allow the user to display the query. I'm not sure why you need to get NotePad involved.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]