Change parent record and the subform record?

[Mike4172]

So far I haven't found a way. In parent record, there is 6,000 records. Each sub of the parent typically has 10-20 records. I know its possible to go to say parent record 205, but can I make it to where I can go to parent record 205 and sub 12 of the parent?

The following code is what I have in the parent form and it works great finding parent record.

Private Sub CustID2_KeyPress(KeyAscii As Integer)
Dim nRecords As Integer
    nRecords = DCount("*", "Multiple Search Two")
    If nRecords = 0 Then
    MsgBox "Customer Not Found in Database.", vbInformation, "Not Found"
   
    Else
    Me.RecordsetClone.FindFirst "[CustomerID] = " & Me![CustID2]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End If
End Sub

The following code works in the subform if the only form I have open is the subform:

Private Sub CustID2_KeyPress(KeyAscii As Integer)
Dim nRecords As Integer
    nRecords = DCount("*", "Multiple Search Two")
    If nRecords = 0 Then
    MsgBox "Customer Not Found in Database.", vbInformation, "Not Found"
   
    Else
    Me.RecordsetClone.FindFirst "[TicketNO] = " & Me![TickNO]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End If
End Sub

Any ideas or suggestions please let me know.

[June7]

Should be possible but why? If there are only up to 20 records, then all 20 should be able to be viewed if the subform is in Continuous or Datasheet view, assuming the Master/Child links properties of the subform container are set so that parent and child records are synchronized.