How to create a Report from the result of a Filter?

[Ashraf]

Hi,

How to create a Report from the result of a Filter?

 

[HiTechCoach]

Hi,

How to create a Report from the result of a Filter?

Welcome to AWF!

With the limited details, I will assume that you mean use the filter from a form.

Set the OnClick property of the command button to the following event procedure:

Private Sub cmdOpenReport_Click()
    If Me.Filter = "" Then
        MsgBox "Apply a filter to the form first."
    Else
        DoCmd.OpenReport "rptCustomers", acViewPreview, , Me.Filter
    End If
End Sub

Hope this helps ...

 

[Ashraf]

Great!
Thank You very much