Please Help! Error 2342

[DBAguy]

In a Form that I've built, the following code produces the following error:

DoCmd.RunSQL "SELECT Email.[User ID] FROM ;"

>>>>
Run-time error '2342':

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

The SQL statement appears valid. What am I doing wrong? Any help would greatly be appreciated.

 

[llkhoutx]

Your SQL isn't an action query. I believe that DoCmd.RunSQL requries a a table being created, updated, appended, etc. - action.

Use your SQL in a DAO or ADO recordset to get the User ID address.