Adding Data to Fields in a Table.

[gregmw]

I have a table called "Data" there are fields in "Data" called "Client" and "Result" I want to return a value into the field called "Result" based on what the "Client" field holds it is easy enough to do with a query but what is the VBA code for it?? Thanks

 

[RobertT687]

Currentdb.execute("UPDATE [Data] SET [Result] = whatever WHERE [Client] = condition&quot

 

[gregmw]

Thank you.