Pick list to access specific record details

[Guest]

I have created a database of clients and for each client there can be or are
multiple contracts. I would like to have a form that displays the clients in
an alphabetical list and upon reviewing the list the user can select the
client to expand the underlying multiple contract details. I've seen this
sort of form before wherein there were clients with multiple contacts,
however, I've lost the database. Any suggestions?

 

[StevenR via AccessMonster.com]

I have created a database of clients and for each client there can be or are
multiple contracts. I would like to have a form that displays the clients in
an alphabetical list and upon reviewing the list the user can select the
client to expand the underlying multiple contract details. I've seen this
sort of form before wherein there were clients with multiple contacts,
however, I've lost the database. Any suggestions?

I haven't done this myself but I have seen it done. You have to create a sub
form inside a subform to create the expanding effect for more information
related to what you select. Hope this helps some.