double click on a list to open record

[mlrucci]

I have a navigation form with a tab for Admin. On that form, there are several subforms. The subforms have a list that corresponds with the records in that subform. I want to double click on the list for that subform (Record Source is a table) to go to that specific record. I use to have this as a single form with the vba
Private Sub lstAttendance_DblClick(Cancel As Integer)
Dim strCriteria As String
strCriteria = "[AttendanceID] = " & Me.lstAttendance.Column(0)
DoCmd.OpenForm "frmAdminAttendance", , , strCriteria, , acDialog
End Sub

but as expected, on double click, it opens the main form and does not stay on the Navigation subform as desired. Can anyone help?

[June7]

Instead of opening a form you just want to find record on the open form? Options are to apply filter or search and move. Search and move can use DoCmd.FindRecord command or involve RecordsetClone and Bookmarks.

[mlrucci]

First, I would like to thank you for your response. Yes, I would like to open the selected record within the currently open form. The list is based on a qry with the ID in row 0. I am fairly inexperienced with vba/Access and am unfamiliar with the above suggestions. Can you please provide more information.

[June7]

This question has been asked and answered many times.
If you search web and forum on the keywords should find many examples. When you have code specific to your db and have issue, post question.