Selecting Records to Send to Report

  • Thread starter Thread starter Jess A
  • Start date Start date
J

Jess A

I have browsed this site many times and have posted a couple of times
and find most of the information helpful. However, I am still new to
Access and don't understand many of the advanced functions of Access,
so please bear with me...

I have a database composed of several tables that specify people's
contact information, meeting names and dates, and another table that
links people to meetings they have attended by matching meeting IDs to
people IDs.

I also have a form that allows me to search for attendee information.
I can enter the meeting name into a text box and press a command
button that runs the DoCmd.OpenReport script, and a report opens with
the names and contact information of the people that have attended
that meeting.

What I (or more realistically, what my employer) would like to do is
to have the results of that search show up (by query or whatever
works), and from the results be able to select certain records to send
to a NEW report (a new attendance list). We have to generate new
attendance lists before every meeting, and this would allow us to pull
existing attendee information from the database instead of manually
making a new list in a Word document every time.

Is this possible? I realize it might be a complicated process, and I
just don't know where to start. I'd appreciate any help and would be
happy to provide more information if needed.

~Jessica
 
You can't click on a report (as far as I am aware), so your first query needs
to put out the results into a listbox with the 'multiselect' property set.
The listbox can be built from a query. Then the user would click on multiple
entries in the listbox and press a command button. The button would invoke
the report.
More details can be obtained from Help.
- David
 
Back
Top