Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SubForm Requery (A2K)

    I know that I
    Cheers,
    Andy

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

    Re: SubForm Requery (A2K)

    Since you want to update SubForm2, it doesn't make sense to requery SubForm1. Try putting code in the After Update event of SubForm1:

    Private Sub Form_AfterUpdate()
    Me.Parent!SubForm2.Requery
    End Sub

    In the above code, SubForm2 must be the name of the subform as a control on the main form. This is not necessarily the same as the name of the subform in the database window.
    If it doesn't work, you can try changing the requery line to

    Me.Parent!SubForm2.Form.Recalc

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SubForm Requery (A2K)

    Hans,

    Thanks kindly. As always, right on the button. Seventy-year olds should stop programming when they're still ahead. Almost.
    Cheers,
    Andy

Posting Permissions

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