GoToRecord from a Combo Box

[TimK01]

I have a form that displays a subset of a table. I want users to quickly jump backwards and forewards between the displayed records rather than scrolling, so I thought an unbound combo box with a row source of the same record set would be the way to go.

But I cant find a method of getting from the selected record in the combo box to one of the selected records, and still having the same record selection to scroll through (ie something to put on a GoToRecord statement). I could do it with filters but then I loose the rest of the selected records.

Any Ideas?

Tim

 

[rajeessh]

Docmd.GoToRecord acDataForm,"FormName",acGoTo,RecordCount

RecordCount can be supplied from Combo Box.