Select multiple records to print from a form

[Mindit68]

I have a database that needs to allow the user to select specific "sample
numbers" (records) to print. I want to use either a form to select the
records to be printed. What is the best way to go about this?

Thank You.

 

[Steve Schapel]

Mindit,

If the numbers to be selected are relatively few, and the number to select
from is also relatively few, you can consider a multi-select listbox.

Otherwise, I favour adding a new Yes/No field to the table that holds these
records, put it on a continuous view form, have the user tick the checkbox
for the records to be included in the report, and base the report on a query
that selects the records according to this Yes/No field.

--
Steve Schapel, Microsoft Access MVP

I have a database that needs to allow the user to select specific "sample
numbers" (records) to print. I want to use either a form to select the
records to be printed. What is the best way to go about this?

__________ Information from ESET Smart Security, version of virus signature database 4149 (20090611) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Kdata]

Steve:

I picked up your response below and have a related question. I am using a
query to generate a table that is a combined result from two separate but
related tables. I am then pulling this info into a form that I'd like the
user to select anywhere from 1 to all of (and any # in between) the records
to print. I tried using the suggestion below, but the result would not allow
me to "check" the box and change the data from one of the original tables. Is
there other ways to do what I'm describing?

 

[Steve Schapel]

Kdata,

Do you mean that the Record Source of the form is a query? It sounds like
the query is a non-updateable query. Can you go to the design view of the
query, select SQL from the View menu, and then copy/paste the SQL view of
the query to your reply here? That will be the simplest way for us to see
why the query is non-updateable.