RunSQL

[murray2402]

I tried a complicated SQL statement with the RunSQL command, but that gave me an error. I tried a simple SELECT statement, and that gves me the same error.

The code that gives me the error is:

DoCmd.RunSQL "SELECT firstName FROM tblClubMembers WHERE memberId = 1;"
MsgBox memberId

The error I get says:

Run-time error '2342':

A RunSQL action requires an argument consisting of an SQL statement.

I'm guessing there is something small that I'm missing/doing wrong here.

 

[KenHigg]

If I'm not mistaken, the DoCmd.RunSQL statement will only execute 'Action' queries, like update, append, etc.

Maybe you can use the dlookup() function -

 

[murray2402]

OK, Thanks I'll check it out