Not sure what I am doing wrong here, this gives me the error "The RunSQL action requires an argument consisting of an SQL statement":
Option Compare Database
Public Sub test1()
Dim strSQL As String
strSQL = "SELECT AttributeList.Id " & _
"FROM AttributeList;"
DoCmd.RunSQL strSQL
End Sub
Tried it again with no variables. with quotes, no quotes, parenthesis...
Option Compare Database
Public Sub test1()
DoCmd.RunSQL "SELECT AttributeList.Id FROM AttributeList;"
End Sub