Export Report based on Filter

P

Piperlynne

Hi,

Trying to use the wonderful Allen Browne's
http://allenbrowne.com/ser-62code.html. Instead of a filter on the form
though, I want to export a report (filtered). Do I just change the me.filter
to something else? Or do I create a report macro and do a run macro command?

Help!!
Thanks!
 
A

Allen Browne

Export? Is this OutputTo? TransferText? Print to PDF? Other?

You may be able to OpenReport in Print Preview with the WhereCondition to
filter it. Then export it, and Access will apply the filter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Report based on forms filter 2
Modify filtered results 10
Refine listbox contents 4
Trying to use the filter on the form to filter report 3
Command btn to open report based on filtered main form 4
Applying a Filter to a Report 1
Filtering and Removing Filter based on a combo box 4
Basic setting form filter criter from text box 2

Top