Recordset.AddNew

[ling_lh]

if I use this method,does it mean every record I added to the recordset would be added to the table that it connects to?
If I don't want that how to manage it?I only want to make the recordset a collection that store my searching result.And the records maybe from different tables and connections.
Thanks.

[Clunietp]

So you want to make your own Recordset/Table that does not get stored anywhere?

Here is an example of that. This RS is created and manipulated by my code, but not physically stored anywhere (except in memory, of course)


Dim rs As ADODB.Recordset
Dim lngCounter As Long

Set rs = New Recordset

'create my temp recordset
With rs
.CursorLocation = adUseClient

.Fields.Append "FirstName", adVarChar, 50
.Fields.Append "LastName", adVarChar, 50

.Open

For lngCounter = 1 To 10
'add my records, just some garbage values
.AddNew
.Fields("FirstName") = "Tom" & lngCounter
.Fields("LastName") = "Clunie" & lngCounter
.Update
Next lngCounter

'shows we have 10 recs
MsgBox .RecordCount

'show value of field
MsgBox .Fields(0)

'go to first record
.MoveFirst

'show that value
MsgBox .Fields(0)


End With