Solved: how to activate filter in report

[jepperly]

Hi there, how can i filter a report? like in DataSheet where the user can select the row and filter it, i want the same thing when the report is displayed to have that kind of functionality, thanks for your help in advance...

[OBP]

jepperly, welcome to the Forum.
The simplest way to Filter Reports is to use a Form to enter what you want to be the filter and then apply that to a query that provides the report with it's data.
You can also use VBA generated SQL to overwrite the Query each time, this is best used with very complicated Filtering where lots of fields are involved.
You can also activate the Report's own Filter using the Docmd statement that opens the Report, but it is less flexible than th eother methods.

[jepperly]

thanks for the help, i guess i'll try what you said regarding with the forms.

[OBP]

If you need further help I can provide examples of how to each type, there are even some already on this forum.