Access Reference

Create a DAO Recordset from a table in the current database

Direct Answer

Create a DAO Recordset from a table in the current database
is part of the Access VBA object model. This reference page documents its syntax, parameters, and typical usage.

Reference

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]

Reference: Access object-model documentation • updated 09/21/2018
. Rebuilt for readability; see the original for complete parameter matrices.