Access Reference

Create a DAO Recordset from a table in the current database

The following code example uses the OpenRecordset method to create a table-type Recordset object for a table in the current database.

“`vb Dim dbsNorthwind As DAO.Database Dim rstCustomers As DAO.Recordset

Set dbsNorthwind = CurrentDb Set rstCustomers = dbsNorthwind.OpenRecordset(“Customers”)

“`

!include[Support and feedback]

Other `Create` members in Access (4)

6 community Q&A using Create a DAO Recordset from a table in the current database

Libraries that work with Create (5)

44 wordsMicrosoft Docs rev. 09/21/2018