Results 1 to 3 of 3
  1. #1
    Candace is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    6

    Question After adding new record it doesn't show or sort without closing and oepening

    I have a mutiple records form that shows all the records in the orders table. On that form I have a button that opens a form to add a new order and one that opens a form to edit the selected order. When I add a new record and save...I can't see it on the multiple records form until I close it and reopen the form. Also, when I use the form to edit the record and save, it makes the changes like I want but it doesn't sort the record according to the sort order. Again, when I close the multiple records form and reopen it resorts as it should. What can do that will make what ever happens when I close and reopen the multiple records form happen without closing and reopening it? I'm very new to all this.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    you must click the REFRESH, or REFRESH ALL button on the menu bar.

  3. #3
    Candace is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2017
    Posts
    6
    Thank you. I added a refresh button to the multiple list form. That will work.

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

Similar Threads

  1. Replies: 7
    Last Post: 03-05-2016, 03:04 PM
  2. Replies: 12
    Last Post: 05-14-2015, 03:48 PM
  3. sort filter, doesn't sort everything
    By deso in forum Queries
    Replies: 4
    Last Post: 01-25-2013, 05:27 AM
  4. Replies: 1
    Last Post: 08-03-2012, 09:02 AM
  5. Replies: 3
    Last Post: 06-02-2011, 07:40 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