J
Judy Ward
I have a form with a button that I want the user to be able to click to run a
query. I keep getting this error:
Run-time error '2342'
A RunSQL action requires an argument consisting of an SQL statement
I have reduced my query to the simplest form to eliminate other errors:
Private Sub cmdFindDBM_Click()
Dim strSQL As String
strSQL = "SELECT DBM FROM tblDBM"
DoCmd.RunSQL strSQL
End Sub
I cannot see what is wrong. I need to build a more complex query and I
can't even get this working! Any help would be appreciated.
Thank you,
Judy
query. I keep getting this error:
Run-time error '2342'
A RunSQL action requires an argument consisting of an SQL statement
I have reduced my query to the simplest form to eliminate other errors:
Private Sub cmdFindDBM_Click()
Dim strSQL As String
strSQL = "SELECT DBM FROM tblDBM"
DoCmd.RunSQL strSQL
End Sub
I cannot see what is wrong. I need to build a more complex query and I
can't even get this working! Any help would be appreciated.
Thank you,
Judy