Results 1 to 2 of 2
  1. #1
    eww is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    125

    Refresh Requery Subform

    I'm trying to Refresh/Requery data on a subform from a completely separate pop up form. This code is set up in an AfterUpdate:



    Code:
    Forms!frmAllProj!sfrmSegmentsSub.Form.Requery
    Forms!frmAllProj.Refresh
    I'm not sure why it doesn't update right away, but it will run the requery, and the only way I can get it to refresh the subform data is if I close the pop up form that this is running from, and then refresh the main form. (which is why I tried sticking the Forms!frmAllProj.Refresh in there)

  2. #2
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    Try this:
    Forms!frmAllProj!sfrmSegmentsSub.Requery

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

Similar Threads

  1. Dependent List Boxes do not refresh using ReQuery
    By weeblesue in forum Programming
    Replies: 2
    Last Post: 03-28-2011, 08:47 AM
  2. Replies: 5
    Last Post: 03-17-2011, 06:21 AM
  3. Access novice help with refresh/requery
    By cvacgreg in forum Access
    Replies: 3
    Last Post: 02-04-2011, 08:51 PM
  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