Access 2000
This code snippet:

Dim strSQL1 As String
strSQL1 = "SELECT ips FROM MainData WHERE (cnum ='123456');"
DoCmd.RunSQL (strSQL1)

Returns the error:
"A RunSQL action requires an argument consisting of an SQL ststement"

What's up?