Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Filter-by-Form

    When Filter-by-Form is used (in a form), I want to run a report based on the same filter criteria.
    It's simple enough to run the report filtered by the matching primary key as the current record in the form, but I cannot figure out how to set the reports filter to match the form's because filter-by-form puts form-specific language (forms!formname.field=...) into the form's filter, which does not work with the record.

  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Filter-by-Form

    Try <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q208/5/48.ASP?LN=EN-US&SD=tech&FR=0&qry=filter>http://support.microsoft.com/support/kb/ar...FR=0&qry=filter</A> records on form&rnk=25&src=DHCS_MSPSS_tech_SRCH&SPR=ACC2000

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Filter-by-Form

    Thanks for your response. This 'solution' is what I first tried. I have finally found SUCCESS!
    There's one detail that I overlooked: both the form and report must be based on the same query (or table), so that the filter's use of the queryname.field syntax will work in both objects. That's the key.

Posting Permissions

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