Results 1 to 2 of 2
  1. #1
    vientito is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2014
    Posts
    26

    edit/update

    If I modify recordset in vba codes by using edit and update method, by the end of that operation does it really modify the recordset held in local memory? I don't suppose it is changing data in the linked database yet until I do a full requery?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    It changes the table record.

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

Similar Threads

  1. Update or CancelUpdate without AddNew or Edit
    By westcoastbmx in forum Forms
    Replies: 5
    Last Post: 11-07-2019, 09:01 PM
  2. Edit/Update function data type mismatch
    By gaker10 in forum Forms
    Replies: 11
    Last Post: 07-09-2014, 02:41 PM
  3. Using forms to immediately edit/update a table
    By TKTheKid in forum Reports
    Replies: 18
    Last Post: 11-19-2012, 11:58 PM
  4. Replies: 0
    Last Post: 03-13-2012, 12:57 PM
  5. combo box disable edit (update)
    By jheacox in forum Forms
    Replies: 10
    Last Post: 09-28-2009, 10:07 AM

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