I'm a newish user to Access and I'm having trouble using a button to view a set of records based on a query with several criteria. I am creating a database to house employee quality assessments. As seen below the subform pulls four records. view of data showing 4 records when I click the circled button it takes me to the expanded view of the record that is selected on the subform. Once I get there however I only have the one record. expanded view of a single record with no other records available on the navigation bar I would like to be able to browse back and forth between all four records rather than closing the form and going back to the summary. Hopefully someone can point me at what I am doing wrong.
Just so it can be marked as answered - Change the record source of the expanded view form to match the calling sub form's record source.
