Select multiple records to print from a form

M

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.
 
S

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


Mindit68 said:
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
 
K

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top