Hi All,
https://www.access-programmers.co.uk...37#post1577037
Thanks in advance
Hi All,
https://www.access-programmers.co.uk...37#post1577037
Thanks in advance
for the benefit of responders who want to respond from this forum, this is the question on the other forum
@fish - providing the link is appreciatedHi 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?
your existing button will be running an insert query to insert into sharepoint, you will need another button to run an update query
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
what is your update query?