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
