How to Add a User Filter in Report

[Guest]

I've created a report in Access 2003 and have added a command button to my
main form which runs a print preview of my report. My question is how do I
allow the user to apply a filter to the data if they want to print only
certain information? Right now it prints the entire database.

Thanks for your help..Scott

 

[Allen Browne]

Typically you provide a form where the user can select the record to print,
or enter the limiting criteria.

A couple of examples:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

Or this one:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

 

[Guest]

Thanks Allen that work perfectly....Scott

Typically you provide a form where the user can select the record to print,
or enter the limiting criteria.

A couple of examples:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

Or this one:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html