go to record from list

[mlrucci]

Good afternoon, I have a form with a subform attached. I have built a list that has all the client's names. I am attempting to click on the list to go to record with same ID in the list. I am working with a navigation form, so I do not want to open another form I would like to go to record. Can anyone help?

[Micron]

You have a subform on a form and that form is on a built in navigation form?

Try

[Forms]![Navigation Form]![NavigationSubform].Form.NameOfYourSubformContainerControl.Form.NameOfControlThatContainsTheID

to get the record ID, then use that in the GoTo method. There might be a shortcut to the control on a subform on a form on a nav form, but I don't use navigation forms, so....