Select rows from a table using lookups

[Guest]

Hi

I am trying to create a query that will select multiple rows from a table
based on data input by a user.

The main table has a thousand plus records in, from which I want to select
records to print address labels from. The user will know what records they
want to use and expects to enter the record numbers (primary key) into a
popup. The popup (or popups!) select the records they need, and then then
label report can use the query to print. I am not at this time concerned
about where the records print on each page, just selecing mutiple rows.

Thanks!

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MultipleLabelsOffsetBatch.mdb" which illustrates how to use a
listbox to select records for printing labels. It also lets you select the
type of label and select the starting position.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L