I created a code for my database to open a recordset and view, edit and update the table, I can't get the code to open the table...
Option Compare Database
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSql As String
Private Sub CustomersRecordset()
strSql = "Select * FROM tblCustomers;"
Set db = CurrentDb
Set rs = db.OpenRecordset("tblCustomers")