Operation must use an updatable query

[Pentlavalli via AccessMonster.com]

Hello all,

In my access mdb file, I have a table "LogReport" in which I have to change a
column "instrumentStatus" value from the table "statusMap".

"statusMap" looks as follows with two columns.

fromSta toSta
ABC 123
DEF 456
GHI 789 .....


Column "instrumentStatus" will have ABC or DEF or GHI.

Based on the above mapping table, I have to change "instrumentStatus" to
either 123 or 456 or 789.

I am using the following query for this.

UPDATE LogReport
SET instrumentStatus = ( SELECT toSta
FROM statusMap
WHERE fromSta = LogReport.instrumentStatus ) ;

But when I try to execute (double click) this query, I am getting the error
"Operation must use an updatable query".

Any help in this regard please ....

Sri

 

[Ken Snell [MVP]]

Try this:

UPDATE LogReport
SET instrumentStatus =
DLookup("toSta", "statusMap", "[fromSta] = '" &
LogReport.instrumentStatus & "'") ;