Must use an updateable Query Error

[DanAuber]

Hi there - I'm getting an 'Operation must use and updateable query' error but I have no idea why.

Here is my code:

UPDATE new_DC2000 SET new_DC2000.Datefield = (SELECT BNZ2002_Date.expr1 FROM BNZ2002_Date;


The select part works on its own and returns one record - both the select field and the update field are data type date/time.

I'm running out of ideas. I thought this was a simple operation !

Please can someone help !

Dan

 

[dhookom]

Try:

UPDATE new_DC2000 SET new_DC2000.Datefield = DLookup("expr1", "BNZ2002_Date");

Duane MS Access MVP
Now help me support United Cerebral Palsy