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.

ANY suggestions would be greatly appreciated!! Thanks!!!

 

[JoeMiller]

See my reply, to your same post in the other forum.

ComboBox w/Info Relevant to another ComboBox Selection
thread700-109363 Joe Miller
joe.miller@flotech.net