Results 1 to 3 of 3

Thread: Report Issues

  1. #1
    Join Date
    Mar 2004

    Unanswered: Report Issues

    I have a form that quries info from a table. The user adds a some info in a few text boxes and presses a button which then updates that table with the new information. I have a button that updates the table and shows the report but the report doesn't show any of the data b/c it has been cleared by the updating process. Can someone help me figure out a way to show a report and update a table in 1 button press. This is the way I get the info from the form to the report now.

    =[Forms]![Term Worksheet]![txtResidual]

  2. #2
    Join Date
    Feb 2004
    Add to your existing commit button command, in the (yourCmdButtonToSaveRecordName)_click code section, Report!(ReportName).requery after the save action.

  3. #3
    Join Date
    Mar 2004
    This is what I have right now. This code shows the report but doesn't update and or close the form. I am not a coder so if you could please help me add/subtracting code I would be greatful. Thanks.

    Option Compare Database

    Private Sub Button10_Click()

    Dim strResp As String

    If Me.Dirty = True Then
    strResp = MsgBox("Do you want to save these changes?", vbYesNo, "Save?")
    If strResp = vbNo Then
    End If
    End If
    End Sub

    Private Sub Command149_Click()
    On Error GoTo Err_Command149_Click

    Dim stDocName As String

    stDocName = "Term Worksheet Report"
    DoCmd.OpenReport stDocName, acPreview
    DoCmd.GoToRecord , , acNewRec

    Exit Sub

    MsgBox Err.Description
    Resume Exit_Command149_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