Results 1 to 4 of 4
  1. #1
    fish001 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    8

    Update Query when record is edited

    Hi All,



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


    Thanks in advance

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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

  3. #3
    fish001 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    8
    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

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    what is your update query?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Record not edited by using the code
    By sukhjinder in forum Programming
    Replies: 2
    Last Post: 03-06-2017, 08:10 PM
  2. Edited Record Lock?
    By mrmims in forum Forms
    Replies: 1
    Last Post: 09-01-2016, 03:55 PM
  3. Replies: 4
    Last Post: 12-03-2015, 04:29 PM
  4. Update seperate table when a record is edited.
    By Homegrownandy in forum Access
    Replies: 4
    Last Post: 08-05-2015, 07:57 AM
  5. Replies: 9
    Last Post: 05-12-2012, 12:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums