Filtered Report?

[NewfieSarah]

Hey all, I have been trying to filter my report However It doesnt seem to be working the way I would like it to. I have the ability to filter on my form, so I can search Wood* and then there will be 27 records displayed so I can view each one speratly. however now I would like to have it on a report. I would like to then click the report button, and view those 27 records on my report as the layout that I have provied I can see multiple on a sheet. Any ideas?

 

[AlexMidd]

Pass the query as a condition in the OpenReport method, e.g.:

Dim Condition as String
Condition = "[FieldName] = '" & Filter & "'"
DoCmd.OpenReport "ReportName",,,Condition

Replace "FieldName" with the field you want to filter and "Filter" with your filter, e.g. "Wood*". You can pass in the contents of a text box with something like "[Forms]![YourForm]![YourTextBox]" in place of "Filter" in the above code.

Have fun! )

Alex Middleton