Results 1 to 4 of 4
  1. #1
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132

    Opening filtered report from another filtered report

    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

  2. #2
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    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!

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    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!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-28-2014, 01:15 PM
  2. Report based on Query but filtered by form
    By michel_annie22 in forum Reports
    Replies: 1
    Last Post: 10-23-2012, 10:40 PM
  3. Microsoft Access 2010 - Filtered report?
    By keaccesshelp in forum Reports
    Replies: 1
    Last Post: 02-21-2012, 03:36 PM
  4. How to send filtered report via email
    By degras in forum Reports
    Replies: 4
    Last Post: 03-31-2011, 09:09 AM
  5. Filtered Report
    By Desstro in forum Reports
    Replies: 3
    Last Post: 06-18-2010, 09:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums