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

    Filter by subForm (2000 SR1)

    I want to be able to Filter-by-Form for selected items in a sub-form. For example, using the Northwind database, I would like to find Orders (Orders form) that have specified Products (Orders subform, based on [Order Details]).

    To state it a bit differently, I want to filter the Order records so that only Orders that have [Order Details] matching the specification will be returned.

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

    Re: Filter by subForm (2000 SR1)

    You can't do exactly that using filter-by-form. If you make a selection in the subform in filter-by-form view, the filter will apply to the subform records only. You'll still see all the parent form records, but only subform records that match the filter.
    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
  •