Opening filtered report from another filtered report

[kelann]

Hi, all!



I have a report (Report_1) whose record source is a query drawn from 2 tables -- OrganizationsT and YPsT.
This report has the following in its page header:

• The organization's name
• Text box caluclated fields that put in a symbol based upon whether "type of organization" check boxs field from the organization's table are True or False.

In the detail section, it has the following:

• People whose true or false checkbox fields indicating their interests match at least one of the organizations "type of organization" checkbox fields. (This is what the query establishes.)
• Text box caluclated fields that put in a symbol based upon whether the various "interest" check box fields from the person's table are True or False.
• Beside each person is a button that opens a report (Report_2) giving more detailed information on that person (conatct info, add'l notes, etc). This report is opened with an Event Procedure, filtered such so that the report opens only for the person's name by the button.

What I am trying to do is this:

• Put a button on Report_1 (preferably in the page header) that is similar to the existing button (which opens Report_2 for the person next to whom it resides), but that will open Report_2 for ALL of the people (who are displayed filtered from a table based upon a query of matching interests/type of org) currently showing on Report_1.

• I've tried a number of different things to no avail.
  
  Thank you so much for any thoughts you might have!
  
  --ak

[kelann]

In other words, a report that would be the same as if I pressed the "Get Info" button beside each of the people appearaing on the page. Rather than getting a report for one of the people, I get the same report, but for all of the people on the page.

Hope that's helpful!

[June7]

Don't understand. If you want report for one person then click the record for that person. If you want all people from report1, apply the same filter criteria to report2.

[kelann]

Ahhh, thank you!

I had tried something *like* this, but I'd gotten errors, so I tried a few other things, and then sort of lost what was the best direction.

Your pointer helped me to focus on the correct track, and it works perfectly.

Thanks again!