You are on the right track Will.

He should have created a simple query first.  Then modified the query to
include parameters, so that it will be more flexible/adaptable.  And
finally developed the form based on the query.

Jim Meagher
=====
Micro Solutions Consulting        Member of The HTML Writers Guild
http://www.ezy.net/~microsol     International Webmasters Association
410-543-8996                MS Site Builder Network - Level 2 member
=====
----- Original Message -----
From: Will Stephenson <[log in to unmask]>

> Hello!
>
> My father-in-law has an interesting problem in Access 97: he wishes to
print
> a set of labels from a database he has created for the Gideons. He has
> successfully created the label report, but has found no way to filter
the
> database, and use the filter output for his labels.
>
> I suggested that he might have to create the report using the filter as
one
> of its components, but that seems really awkward. Any ideas?

             PCSOFT maintains many useful files for download
              on our web site - visit our download page at:
                     http://nospin.com/pc/files.html