ComboBox w/Info Relevant to another ComboBox Selection 1

[toddOne]

Recently designed a db w/ tblManager, tblCoManager, & tblLoan. The tblLoan contains both fldManagerID and fldCoManagerID to create relationship. I need to design a form that searches for a manager(ComboBox), and then possibly have another ComboBox populated with only the CoManagers that share a LoanNo with this Manager. Then finally I would like to be able to choose from the loans these two have in common.

thought about possibly having a continuous subform contained with a another subform.

<b>ANY</b> suggestions would be greatly appreciated!! Thanks!!!

 

[JoeMiller]

See this FAQ by RickSpr

How do I limit the contents of one combo box based on the selection in another?
faq702-681

HTH Joe Miller
joe.miller@flotech.net