Recent content by gaatjaat

I thought I had tried that and got a different error, but I just now removed dbOpenTable and now I have a syntax error in FROM clause. Something I have not seen yet.

Please help me, this one line of code has cost me an entire day already. I am using a SQL query to open a recordset in the following code: Private Sub CommandInstructors_Click() Dim dbs As DAO.Database Dim rs As DAO.Recordset Dim IID As DAO.Recordset Dim ClassNumber As Long Dim strSQL As...