Copying values froma query to a table

[komputatek]

I want a comand button to copy a value from a query to a table. It has to replace the exisitng value in the table. I'm using an exit button so that these values are updated at exit.

 

[PHV]

Take a look at the UPDATE sql instruction.

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