I have a form with a sub-form, and the sub-form is based off a select query with a userID. I want to be able to have a way where if the user selects a row from the sub-form, they can then press a command button and a second form is opened with ONLY information that is related to the selected record is displayd.
Is this possible in Access 2013 and if so, how would you achieve such?