Hi,

Here is how I am connecting to access database:
rs As ADODB.Recordset
rs1 As ADODB.Recordset

Set cn = New ADODB.Connection

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= " & MyAppPath & "\Vehicle_sales.mdb"

cn.Open
Set rs = New ADODB.Recordset

sSql = "SELECT * FROM Payments "
sSql = sSql & "WHERE PO_id = " & POid & " "
sSql = sSql & "AND Cust_id = " & Cid

Set rs = cn.Execute(sSql)

No I want to equate rs1 = rs. How can I do that?

Thanks in advance.