How do I jump to a specific record in a list

[pmo]

A have a form that isn't based on a query. Purely cosmetic. Within this form I have a form that is a list of clients and their details. (A bit like a datasheet)
The list is now very long.
I have a combo box on the main form. When I select a client from the list I would like to be able to jump to the specific record in the subform list.

My knowledge of code is almost nill but am trying the following.

Private Sub Combo24_AfterUpdate()
DoCmd.GoToControl ("ClientListF&quot
DoCmd.GoToRecord , , acFirst, ("Client Id&quot = Forms("ClientMainF&quot("Combo24&quot
End Sub

This is not erroring but it doesn't work.
Can any one help?

Wayne

 

[Savil]

It's as simple as this

Private Sub Combo24_AfterUpdate()

Me.RecordsetClone.FindFirst "[Client ID] = Me.Combo24"
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub

Regards Savil

 

[pmo]

Thanks Savil,
I'll give it a go.
Wayne

 

[pmo]

Savil,
No luck..

The combo box is on the main form but I need it to select from the list that is on a subform.

Main form is "ClientMainF" with Combo24 on it.
The list is the subform "ClientListF"

Can you offer further advice?

Wayne