Dealing with neighboring records in a sorted table

[Mile0]

How can I code more than one record on a screen form? So that my user sees:

- Name - - Address - - D.O.B. - - Status -
Blow, Joe 2323 Main Street Aug-10-1927 Eligible
Blow, Joseph 3223 Main Street Feb-09-1977 Ineligible
Blow, J. 1515 Oak Street Jan-22-2001 Formerly Eligible

and chosing one expands a new screen with further information?

MileZero

 

[mph1]

You could put your headings

Name - - Address - - D.O.B. - - Status -
in a form and the data

Blow, Joe 2323 Main Street Aug-10-1927 Eligible
Blow, Joseph 3223 Main Street Feb-09-1977 Ineligible
Blow, J. 1515 Oak Street Jan-22-2001 Formerly Eligible
in a subform. Then in the OnEnter or each field use code to open a separate form with the specific data.


An investment in knowledge always pays the best dividends.

by Benjamin Franklin