Access 2007 Filter & Labels

  • Thread starter Thread starter Conrad
  • Start date Start date
C

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
 
Is this action normal? Is there a way to save the label report so that the
filter stays in effect?
Click to expand...

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

John W. Vinson [MVP]
 
Back
Top