Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Kingwood, Texas, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print search criteria on report (Access 97)

    I would like to know how to print the search criteria on a report in cases where the search will vary from printout to printout. I generate the query the report is based on using VBA, so I already have the "Where" string. I would like to be able to print that string on the same report that displays the query results, but I can't think how. The query and the report are generated when I hit OK on a search form. But how do I add the search string to (say) the report header?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Print search criteria on report (Access 97)

    Store the WHERE clause in a control on the search form; it doesn't even have to be visible. Then place a control in your report's Header, and as its controlsource, reference this hidden control on the form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Kingwood, Texas, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print search criteria on report (Access 97)

    Thanks!

Posting Permissions

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