Access 2007 Filter & Labels

[Conrad]

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

 

[John W. Vinson]

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]

 

[Conrad]

Hi John,

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

Thank you very much.