I have Access 2007. I set up a database with names & addresses. I turn on a
filter to limit the amount of data that I want to print. I used the label
wizard and came up with a label report that prints fine. I save every thing
and close Access 2007.

The problem is when I bring up my database again, and I look at my label
report, there are labels for all of the records in the database. I have
noticed that the filter has been turned off. Even when I turn the filter on
again, my lable report shows all of the records in the database. To get my
correct labels to print I have to go through the label wizard again.

Is this action normal? Is there a way to save the label report so that the
filter stays in effect?

Thanks

On Fri, 4 Jan 2008 14:51:03 -0800, Conrad <(E-Mail Removed)>
wrote:

>Is this action normal? Is there a way to save the label report so that the
>filter stays in effect?
>

Rather than using a filter, base the report on a Query with criteria to select
the desired records.

John W. Vinson [MVP]

Hi John,

That did it. I set up a query to limit the records.

Thank you very much.

"John W. Vinson" wrote:

> On Fri, 4 Jan 2008 14:51:03 -0800, Conrad <(E-Mail Removed)>
> wrote:
>
> >Is this action normal? Is there a way to save the label report so that the
> >filter stays in effect?
> >
>
> Rather than using a filter, base the report on a Query with criteria to select
> the desired records.
>
> John W. Vinson [MVP]
>