Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Provided Answers: 3

    Unanswered: Macrofor Multiple Reports


    I have created a macro that opens 6 different reports, based on 6 different queries each query is based on one set of criteria. So when I run the macro I am prompted six times for month/year, once for each report. Is there a way to enter the criteria only once and all reports drive from that? Thank you for your help.

  2. #2
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 2
    Design a form with controls on where the users can enter or select their criteria values. Then amend the reports' source queries to look to this form for their criteria instead of prompting for them. You can also invoke the macro from a button on the form, making it self-contained.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts