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