Update syntax help 1

[luismagally]

Hi, I've got a some values in a couple of textboxes that I need to update in a specific point in a table (2 record updates, one after the other). I've got the IDs for the primary keywhere the insertion must be made. I need to update the values but don't know the right syntax of the SQL command for access. Any help?

Thanks

 

[PHV]

UPDATE yourTable SET yourField = newValue WHERE yourPKfield = PKvalue

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886