Repeated Calls to a Report

A

Alasdair

I want to use a list of recipients selected within a form
to call a single report repeatedly for each selected
recipient.

I can't see how to access the contents of the form one
record at a time to pass the criteria to the report (via
it's underlying query) !

Any help appreciated !

Regards,

Alasdair
 
R

Roger Carlson

On my website is a small sample database called "CreateQueries2.mdb". One
of the examples there shows how to create the query behind a report based on
a multi-select listbox on a form. Maybe it will give you some ideas.
 
G

Gary Miller

Alasdair,

You haven't given us much on how the list is being selected,
but you can roll through the records with a loop using the
RecordsetClone of the form and do a OpenReport for each that
is flagged within the loop. You could also use the same
approach with a multiselect listbox of the recipients.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 

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

Similar Threads

Can I save a sql statement generated by a search form? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Repeated Calls to a Report 0
Need a macro to create a separate document that lists all capitalized words 6
Insert Index into a Table 1
You'll need a new app to open this about link 1
using a sub report for totals in main report 0

Top