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.