filter by form for report

[stephenaa5]

I have two tables, Customers and Jobs. There is a JobQuery that combines both for viewing on a split form DispatchForm.



DispatchForm shows the currently highlighted job in great detail at the top of the screen, while having the datasheet view below the rail show various pieces of data upon which a user might filter information. The filtering works fine, now we need output.

I would like to have those filters that are selected be applied to a report, so they can get output. Currently, we go to a report filtering screen, which is not pretty.

I have tried to create a button that essentially has the following procedure:

Private Sub cmdOpenReport_Click()
DoCmd.OpenReport "rptDISPATCH", acViewPreview, , Me.Filter
End Sub

What happens is that the report launches, but I get an error that the query is looking for whatever data the user has selected as a filter. Clearly I'm conceptually wrong.

Thoughts?

Thank you,

Stephen.

[Datagopherdan]

Hi Steven,

I'm not sure of what field you are trying to filter on but here's a basic sample of how to apply a filter to a report in VBA. You would just create an unbound text box where the user would enter the criteria or base it off an existing field in a form.

    strMyField = "[ml_ID]= " & Me.txtMyField 
DoCmd.OpenReport "YourReport", acViewPreview, , strMyField