Results 1 to 2 of 2

Thread: Refresh Form

  1. #1
    Join Date
    May 2004
    Posts
    86

    Unanswered: Refresh Form

    I have a command button that refreshes my form data. Is it possible to refresh the form data then run a query??? Where could a place a macro in this code to run my query after the form is refreshed?


    Private Sub Command710_Click()
    On Error GoTo Err_Command710_Click


    DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

    Exit_Command710_Click:
    Exit Sub

    Err_Command710_Click:
    MsgBox Err.Description
    Resume Exit_Command710_Click

    End Sub

  2. #2
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146
    Private Sub Command710_Click()
    On Error GoTo Err_Command710_Click

    Dim stDocName As String
    stDocName = "QUERYNAME"

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
    DoCmd.OpenQuery stDocName, acNormal, acEdit

    Exit_Command710_Click:
    Exit Sub

    Err_Command710_Click:
    MsgBox Err.Description
    Resume Exit_Command710_Click

    End Sub

Posting Permissions

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