Create a recordset

[Bill]

How do you create a recordset ?

 

[Kelvin]

You need to be more specific. A recordset is the underlying data being
anything. A table is a recordset, a query, an SQL statement, plus others.
Exactly what do you want to do?

Kelvin

 

[PC Datasheet]

Bill,

There are many ways, here are two ---

If you want to make a recordset of the records in a form:

Dim Rst As DAO.Recordset
Set Rst = Me.recordsetclone

If you want to make a recordset of a table or query that is not part of a form:

Dim Db As DAO.Database
Dim Rst AsDAO.Recordset
Set Db = CurrentDb
Set Rst = Db.OpenRecordset("NameOfTableOrQuery",dbOpenDynaset)