doCMD.RunSQL Problem

[morpheusdreams]

I run the following from a command button:

   Dim strSQL As String
    
    strSQL = "SELECT tbl_Agents.[AgentName], tbl_Agents.[Aspect_No] " & _
            "FROM tbl_Agents " & _
            "WHERE tbl_Agents.[TM_ID] = " & Form_frm_TMs.dd_TMID.Value & ";"

    DoCmd.RunSQL (strSQL)

And get an error of "A runSQL action requires an argument consisting of an SQL statement."

When i use the immediate window to get the string and place it into the sql query window and run it it works fine.

?strSQL
SELECT tbl_Agents.[AgentName], tbl_Agents.[Aspect_No] FROM tbl_Agents WHERE tbl_Agents.[TM_ID] = '2';

what am i doing wrong?

 

[morpheusdreams]

SELECT tbl_Agents.[AgentName], tbl_Agents.[Aspect_No] FROM tbl_Agents WHERE tbl_Agents.[TM_ID] = 2;

Sorry, that's how it appears in the immediate window

 

[JerryKlmns]

Right from help file
DoCmd.RunSQL needs a valid SQL statement for an action query or a data-definition query.

You are running a select SQL statement

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886