hi i hope someone can help me with this i need to be able to post a value to only one field in an allready populated sql table.

so when the pk is 4 set value as 400.00 i have an ado connection and select statement but it tries to put in a line instead of just one field that i need.

thank you

you need sql UPDATE statement, like this:
UPDATE your_table
SET field_name = 400.00
WHERE pk_field = 4