Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform Requery / Refresh (2000)

    Hi,

    I have a tab control with a sub form on. The subform is based onthe query result of a page of the tab control the sub form fits on. I have a button that is suppose to requery the data in the subform, however the only way I can get it to work is to use the following code:-

    Private Sub cmdrefresh_Click()

    Me.frmHuntingSub.SetFocus

    Me.frmHuntingSub.Requery

    End Sub

    The causes the sceen to flicker when it does it.

    I have tried me.frmHuntingSub.requery but this does not requery the subform. Any ideas where I could be going wrong?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform Requery / Refresh (2000)

    You could try setting DoCmd.Echo False at the beginning of your code, and DoCmd.Echo True at the end. If that doesn't help, you'll have to provide detailed information or post a stripped down copy of your database.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform Requery / Refresh (2000)

    Did the trick, thank you.
    Best Regards,

    Luke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •