are you setting the Parent/Child fields to the same ID field? Sounds like you are not filtering by the Parent ID
--- In [email protected], "brookbumm" <[EMAIL PROTECTED]> wrote: > > i have been using office access 2000 and 2003 for many years > utilizing the command button feature to transfer control from a > primary form and select specific detail records from a sub form. > > since upgrading to office access 2007 with win vista, i have had > problems using this feature. > > using the command button wizard, i click " open the form and find > specific data to display " and press next. i then select a field > from primary form and select a field from detail form [ field names > are exactly the same name ] and then click < - > to show matching > fields and click next. > > using primary form, i select record that i want to view the detail > records and click the command button, and no matter what record i > select in the primary form, it always displays all the records from > the detail, not just the specific records that i am trying to view. > > the location of all my data files have been placed in a trusted > location as well as the check box is selected to include all sub > folders ... > > any help would be appreciated thanks mike >
