I need to creat a table of Contents (TOC) in Access 2007

[taylor58285]

I have a Access 2007 file of a club's membership this app produces a page for each member with their particulars and a photo. I wish to create an additional page as a Interactive Table of Contents The "Name/Last/First/MI" field has been indexed. Where do I go next?

[ranman256]

you make a continuous form of records, frmMemList
user selects record, click DETAIL button on form header
this opens the detail single record form via:

docmd.openForm "frmMemberDetail" ,,,"[id]=" & txtID


frmMemList can also have filters to filter on Last name letter, or name.
or
a client index list inside the single record detail: see photo

[taylor58285]

Thanks ranman256 !
The sample photo is nearly what I am looking for, I am a true novice using ACCESS. What are some of the detailed steps to achieve this result?

[ranman256]

the list displays all records, then filters the 1 record selected in the list
various filters on the list to pick via queries.ClientSample.mdbClientSample.mdb (cbo box, or Alpha filter)

[taylor58285]

ranman256 Thanks for the reply.

I like the display you provided. My Access file has the name field indexed how do I proceed to get a result similar to your sample?