Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Refresh subform while after update


    I have a subform where I have a combo box with an after update

    after the user puts in a rating, a popup window appears with expanded controls for a more detailed review/rating

    If I close that popup I get an error when trying to refresh the subform using

    If CurrentProject.AllForms("frmSchools").IsLoaded Then
    Forms!frmSchools!SchoolsBookingsListSub1.Requery
    End If 'ends the check to see if the report is open

    something about it wanting to save before closing...

    this even doesn't happen if I put it on the double click event.

    I am guessing the event "after update" is still occurring?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    sigh sorry guys

    DoCmd.RunCommand acCmdSaveRecord

    fixed

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

Similar Threads

  1. How To Refresh The SubForm?
    By Mahendra1000 in forum Access
    Replies: 11
    Last Post: 10-01-2013, 02:48 PM
  2. Subform refresh
    By Ruegen in forum Forms
    Replies: 13
    Last Post: 08-10-2013, 03:05 AM
  3. Replies: 13
    Last Post: 02-04-2013, 04:08 AM
  4. Replies: 15
    Last Post: 11-09-2010, 04:27 PM
  5. refresh subform
    By asmith in forum Forms
    Replies: 5
    Last Post: 09-27-2010, 10:58 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