SQL Error

[Steve S]

The follpwing code in an event procedure produces the error:
A RunSQL action requires an argument consisting of an SQL statement:

Dim strSQL As String

strSQL = "SELECT Penalties.Type,Penalties.Penalty FROM Penalties;"
MsgBox strSQL
DoCmd.RunSQL strSQL

the messabe box displays what seems to be a valid sql string. It look like:

SELECT Penalties.Type,Penalties.Penalty FROM Penalties;

when I cut the text between the " marks and paste it in a query it works
just fine and display the expected results.

what am I missing here???

 

[Ken Snell \(MVP\)]

RunSQL is used to run an action query, not a select query. Your query is a
select query.

Try
DoCmd.OpenQuery strSQL

 

[Steve S]

Duh?? The message even says - action- but i missed that. thanks