Results 1 to 3 of 3
  1. #1
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154

    Editing the form and subform

    Dear all

    I have no idea where and why, the data is not updated immediately.

    i updated the form and the table is not updated, i have to refresh it

    The form is created from a Query , and the Query is created from a table.



    Eric

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    normally, this is immediate. (if your data is on a single form)
    If you are entering on 1 form, and want to see it on another form, then yes, you must click refresh btn.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Erictsang View Post

    ...the data is not updated immediately...
    What, exactly, do you mean by this? If you're speaking of entering data into a Record, on a Form, and then looking directly at the Table, the data won't show in the Table until the Record has been saved...either explicitly, thru code...or by moving off of the Record or closing the Form.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 3
    Last Post: 12-03-2014, 01:40 PM
  2. Adding/Editing Records through a subform
    By Antinomy in forum Forms
    Replies: 17
    Last Post: 06-30-2012, 07:29 PM
  3. Editing Subform Data
    By tylerg11 in forum Forms
    Replies: 4
    Last Post: 12-16-2011, 02:33 PM
  4. Replies: 1
    Last Post: 11-29-2011, 07:43 AM
  5. Editing in a subform within a report
    By Malachi Constant in forum Programming
    Replies: 9
    Last Post: 10-28-2011, 06:50 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