Requery report after edit form closes

[tuniwes]

Hi



I am opening an edit form from a button in my report header

Private Sub Image133_Click()
DoCmd.OpenForm "chase notes form", , , "ID = " & Me!ID


End Sub

On closing the form I can refresh the report so that it shows the changes made in the edit form with a button that has Dcmd requery on the click event

My question is how to automatically apply the requery command once the form closes without the need for the refresh buttton?

Thanks

Ian

[Bob Fitz]

Put the code that is used by button in the forms On Close event

[tuniwes]

Hi Bob

That's what I expected would work but it doesn't although the same command on the button in the report header does

[Bob Fitz]

In the OnClose event of the form use:

Reports!ReportName.Requery

Substitute ReportName with the name of your report

Edit:
If the report is closed before the form is closed, the code above will cause an error.
you could handle that with some error code. Something like:

Private Sub Form_Close()   
On Error GoTo Form_Close_Error


Reports!YourReport.Requery


   Exit Sub


Form_Close_Error:
    If Err.Number = 2451 Then
        Exit Sub
    Else
        MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Form_Close of VBA Document '" & Me.Name & "'"
    End If
End Sub