Applying an SQL statement to an ADO recordset...

How could I apply an SQL statement to the following recordset?:

cn.Open
Set rs = New ADODB.Recordset
rs.Open "Customers", cn, adOpenKeyset, adLockPessimistic, adCmdTable


Would I have to set it in the rs.open line?? If so where should it go?

Thanks in advance!

Rob.

Try

VB Code:

rs.Open "SELECT * FROM Customers", cn, adOpenKeyset, adLockPessimistic, adCmdText

but replace "SELECT * FROM Customers" with your query