Record navigation

[ramindya]

I have a table named TableA which consists of following : ( ID is primary key )

ID SSN Lastname PHONENUMBER
1 123456789 ASHOK 5097863736
2 123456789 ASHOK 6572527257
3 897262562 KUMAR 9897867298
4 897262562 KUMAR 6572357373

The subform shows lists data by individual person one person at a time which means

ID SSN Lastname PHONENUMBER
1 123456789 ASHOK 5097863736
2 123456789 ASHOK 6572527257

To navigate from one record to next in the subform I use the record navigation which defualt comes with ms access.

Problem: The mainform also has navigation but it goes through all the records sequentially.
But I want to go next record ( a custom navigation or something like that ) that is..

FROM

1 123456789 ASHOK 5097863736

TO

3 897262562 KUMAR 9897867298

Can somebody let me know how to that ?

Thanks !!

 

[MarkK]

double post