Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Covington, LA
    Posts
    46

    Unanswered: need simple help

    i have a tab control that contains a subform and a command button. when i push the command button it opens a data entry form. when i close the form, i would like to have the On Close event requery the subform on that page of the tab control on the form. i tried every type of code i could think of to make it work. does anyone know what code i could use?

    this was my latest failed attempt to refresh the data.

    Private Sub Form_Close()
    [Forms].[frmRequestsByRequester].[fsubCommunicationLog].Requery
    End Sub

    Thanks
    Unique like everyone else,
    Clark
    -------------------------------------------
    POSTING IS THE TERRIBLE SECRET OF SPACE!

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Try:
    [vba]Forms![frmRequestsByRequester]![fsubCommunicationLog].Form.Requery[/vba]

    Check attachment for Subform Syntax.

    Cheers,
    Andrew
    Attached Files Attached Files
    Last edited by Bunce; 07-18-02 at 08:08.
    There have been many posts made throughout the world.
    This was one of them.

  3. #3
    Join Date
    Mar 2002
    Location
    Covington, LA
    Posts
    46
    it worked!
    bunce, thanks for the help and the helpfile! i do believe that will come in handy. thanks again. good luck.
    Unique like everyone else,
    Clark
    -------------------------------------------
    POSTING IS THE TERRIBLE SECRET OF SPACE!

Posting Permissions

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