Results 1 to 2 of 2
  1. #1
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52

    Open multiple reports based on same criteria but with different queries

    Hi guys,



    This may be a simple issue but here it goes:

    I want multiple reports to open by the click of one button. This is the easy part.

    I want all the report queries to run based on the same criteria. I know I can just add a field in a form from wich the common criteria value is read.

    However, how do I handle the situation where I would like the user to specify either to show all records in the reports or just a single record? I do not want all queries to request a Like[] input box (** will return all records) in order to genereate the reports. The user should only specify all records (**) or a specific single record once, and all the queries should then use these specifications.

    Thank you very much in advance!

    BR

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    here is a link to a post which I think will help you. Follow the example by Datagropherdan
    https://www.accessforums.net/reports...port-5411.html

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

Similar Threads

  1. Replies: 0
    Last Post: 05-14-2010, 07:28 AM
  2. Replies: 0
    Last Post: 04-08-2010, 12:22 PM
  3. Replies: 1
    Last Post: 02-03-2010, 08:17 AM
  4. Reports based on queries
    By Merkava in forum Reports
    Replies: 13
    Last Post: 12-14-2009, 11:21 AM
  5. Open form based on Subform criteria
    By Suzan in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 02:28 PM

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