Run Time Error 3073

[maccten2000]

I have the following code

' Set Variables
    strSQL = "UPDATE " & strQueryDef & _
            " SET " & StrColDest & " = (SELECT " & StrColSrc & " FROM " & strQueryDef & ");"
            
                   
    ' Insert Records Into Table
    DoCmd.RunSQL strSQL

This code takes a column which is text and copies the information into a column which is set to Long Number Type within the same table

However i am getting the following error

"Operation Must Use an Updateable Query"


Can Anyone help me out

Cheers

 

[Remou]

What is the value of strQueryDef and how many records does it return?

http://lessthandot.com

 

[dhookom]

Your subquery will return every record in strQueryDef. I think this is what you want if the dest and src are from the same record. Also, your code comment about inserting records into table is misleading.

    strSQL = "UPDATE [" & strQueryDef & _
        "] SET [" & StrColDest & "]= Val([" & StrColSrc & "])" 
            
   ' Update Records In Table
    DoCmd.RunSQL strSQL

Duane
Hook'D on Access
MS Access MVP