Update table via VBA

[webisti]

Hi
I am using this code to update a table but it does not work out, and can`t figure where I m doing the mistake:

 ' add the first condtion - higher than 10k - to the table
            strSQL = "UPDATE Orders SET Orders.IC = ' Pls. contact Supervisor - Value over 10K USD' "
            strSQL = strSQL & "WHERE (((Orders.Value)>9999.00) AND ((Orders.PURCHASE_ORDER) Not Like ' 44* ' )); "
           CurrentDb.Execute (strSQL)

Field Orders.Value is number ( fieldsize - double, format standart decimal places 2)



any ideas
Thanks

Webisti

[June7]

Value is a bad name for a field because it is a reserved word. http://office.microsoft.com/en-us/ac...010030643.aspx

Why doesn't it work - error message, wrong results, nothing happens?

[webisti]

Nothing happens and value is not the real word but I just renamed to have it easier to explain.

[webisti]

I tried to do it via a query:

UPDATE Orders INNER JOIN O_OVER10K ON Orders.Purchase_order = O_OVER10K.Purchase_order SET Orders.IC = [O_OVER10K]![OVER10K];

but it gives me an error message : operation must use an updateable query access.

Any ideas?

Webisti

[webisti]

I finally solved it by posting the results to a rtemp table then updating the main table.

Thnx

Webisti