Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Refresh report (97)

    Refresh report
    I

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Refresh report (97)

    You can put a button on a report but that's only for the looking. There is no possibility to make them working.
    Put the button on a form where you can write code to create a where condition that you send to the report with the DoCmd.OpenReport.
    See the help file for the syntax of DoCmd.OpenReport
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Refresh report (97)

    A report is not like a form. It makes no sense to add a button to a report - you would not be able to click it.

    What you *can* do is:
    <UL><LI>Create a form with text boxes, combo boxes, check boxes, ... to filter the report. Microsoft describes how this can be done in MSKB article Q147143. This also contains a link to a downloadable sample database.
    <LI>Create a command bar (tool bar) with combo boxes, text boxes etc. to filter the report.[/list]

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Refresh report (97)

    As both Francois and Hans have pointed out, you can't do that. What you *can* do, though, is create a custom toolbar that loads at the same time as the report. It's perfectly possible to use that toolbar to bring the criteria form back up so that you can rerun the report with new criteria.
    Charlotte

Posting Permissions

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