Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2004
    Thanked 0 Times in 0 Posts

    Filtering a Subreport and Report from Openreport (Access XP)

    I have situation where I have a form to access a report. In the form the user will input a date and a percentage, then click a button. Next, the report would open, filtered based on the values entered. The problem I'm having though is the date is a part of the main report, but the percentage is part of a sub report.

    I have tried writing the filter to the subreport, then opening the report, but the problem with this is the main report does not get filtered. Instead the subreport just doesn't show for those records.

    So what I'm trying to do is get both the subreport and report to be filtered, when not all the information is in both.

    Any idea's on how to go about doing this.
    If I didn't explain anything well enough, please let me know and I will Clarify

    <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Filtering a Subreport and Report from Openreport (Access XP)

    Create a query to act as Record Source of the subreport. Specify criteria for the percentage field in the form


    where frmSomething is the name of the form, and txtPercentage is the name og the text box on the form. Set the Record Source of the subreport to the name of the query. If the subreport is linked to the main report, you'll probably have to set the Link Master Fields and Link Child Fields again.

Posting Permissions

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