How do I requery subform within a navigation control?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    How do I requery subform within a navigation control?

    I have a situation where I have a popup form that when I close it, I want it to requery the subform that is opened in the currently selected navigation control tab. My problem is that I don't know how to reference it. I have tried
    Code:
    Forms!frmHome.NavigationControl0.Requery
    Forms!frmHome.NagigationSubform.Requery
    Neither one does anything. I can't think of anything else to try.
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3655

    #2
    There might be some info here: Navigation Controls.

    I know Nav Controls are a real bear to understand. MS didn't do a good job of making them easy for us. You may also try to Contact Z, as he seems to be the only one I know who has any slight grasp of how to work with them in VBA.

    Comment

    • Seth Schrock
      Recognized Expert Specialist
      • Dec 2010
      • 2965

      #3
      Thanks twinnyfo. That had the answer that I was looking for. I also discovered that I had changed the data, but it hadn't been saved when I tried to do the requery so I wasn't seeing the results like I thought I would.

      Comment

      • Brilstern
        New Member
        • Dec 2011
        • 208

        #4
        @Seth
        Not saving my VBA before running it again gets me so much!

        Comment

        Working...