Error: Operation must use an updateable query

Hello,

I got this error "Operation must use an updateable query"
I dont understand what does it mean please someone help me out with this.

Thanks in advance.

check this out: http://support.microsoft.com/default...;en-us;q175168

On which line you got the error?
Can you put your code please?
Is it access SQL?

OK here it goes.

Code:

---

UPDATE [Data Extract]
SET [Data Extract].[Unit a] =
(SELECT  [Unit c]![Unit b]  FROM [Unit c] WHERE  [Unit c]![Country] ="Not Listed")
WHERE ((([Data Extract].[Unit a]) Is Null));

---

Using a subquery in an update query is not allowed.
instead do this.

Code:

---

UPDATE [Data Extract]
SET [Data Extract].[Unit a] =
DLookup("Unit b","Unit c", "Country ='Not Listed'")
WHERE [Data Extract].[Unit a] Is Null;

---