Create a recordset

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
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)
 
Back
Top