Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178

    Unanswered: Print a Where Condition

    I'm running a report with a complicated Where Condition. The report could be several hundred pages long, depending on that condition, which is built by a VBA routine, and based on the selections of various list boxes.

    Because of the complexity of the report, it's almost impossible to prove that I used the correct criteria as requested by my boss, and I want to print the where condition as part of the report - it could be anywhere between a cover page and a final page, it doesn't matter.

    I'm having trouble capturing the text of the condition in the report. Putting it in an OpenArgs argument didn't work. I'm using A2K3.

    Any ideas?

    Thanks in advance,

    Sam

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Put a text box in either the Report Header or Report Footer (beginning or end respectively) and set the Control Source of this textbox to either
    Code:
    =[Report].[RecordSource]
    OR
    Code:
    =[Report].[Filter]
    Depending on if you dynamically set the recordsource or just set the filter.

    HTH
    Me.Geek = True

Posting Permissions

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