Can I make a report of a filtered form in Access?

M

mjlee

I have a database of work orders and need to print out all of those that have
an 'open' status. I can filter the form so that only those I need are
visible, but I'm having problems printing these. I would like to somehow
covert that form of filtered values into a report. Is this possible using
Access 2003? If I just print the form itself, some of the info runs into the
next page and I would like it to look more report like. Thanks.
 
A

Albert D.Kallal

Sure, just pass the report the filter.

Note that a report as both a "filter" option, and a "where" clause. The main
difference between the two is that the filter can be changed AFTER the
report opens.

Anyway, lets just use the "where" clause.

Put a button on your form with the following code"

me.refresh ' force a disk write
docdm.OpenForm "myReprot",acViewPreview,,me.filter

You only need the me.refresh if edition can occur on the current record
(since, we must fore a disk write of that data, since the report pulls from
disk).
 
Top