Update getting Wierd Error

[Dthomas261]

I am trying to do something very simple... I thought... 4 hours ago!

UPDATE tblDailyWorkHoursDetail SET tblDailyWorkHoursDetail.[Department ID] = (select dept_id from tblholddeptinfo where tblholddeptinfo.id = tbldailyworkhoursdetail.id);


I am trying to get information from one table to the other... The two tables have the same ID fields, I just need to merge the info in the two tables.

I get the error: "Operation must use an updatable query"... I'm not sure how this applies to an UPDATE statement.

Thank you for your assistance.

 

[Sohaila Taravati]

Do you thing the word UPDATE at the begining of your query has something to do with it! Anyway, if you want to merge the two tables use Union query

 

[Rich]

You either have to use DoCmd.RunSQL "UPDATE etc
or DB Execute or an Update Query