Pick list to access specific record details

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
smitee said:
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?
Click to expand...

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.
 
Back
Top