Update Query when record is edited

[fish001]

Hi All,

https://www.access-programmers.co.uk...37#post1577037


Thanks in advance

[CJ_London]

for the benefit of responders who want to respond from this forum, this is the question on the other forum

Hi All,

I have two tables.
One connected to SharePoint and One Local
Table.
When user create from a form, it will save in local table. & when
user presses the button, it will create the record in the sharepoint table.
However, when user edit a record, it doesn't create any record.

How do i
use query to update records from one table to another when records are edited?

@fish - providing the link is appreciated

your existing button will be running an insert query to insert into sharepoint, you will need another button to run an update query

[fish001]

Hi Ajax,

Thanks for your reply.
I have done a few update query.
However, it either copy the whole data again or create a new one for the modified data.
I want it to be updated on the record itself rather than creating a new one record.

Please help.

Many thanks

[CJ_London]

what is your update query?