Unanswered: Combo Box not showing all relationship results...
Attached is a copy of my current Database.
When going from Bank and Broker Search screen to the Details screen, you come across a problem.
For companies with 0-1 Address, the information in the Combo Box Address 1 displays the correct information (no address, or one address), but...
In the event that the Company has multiple address, only the first on the list shows. (as in the case of A G Edwards...
The Query pulls the correct information, the combo box just does not want to show it.
In addition, while troubleshooting I'm finding that if I have the Record selector enabled, If i change to the next record, the Combo box shows the next record, but again when I press the pull down button on the combo box it only shows the current record. Maybe that helps?
you child form doesn't allow record navigation
so \as I read it you are expressly forbidding someone to see anything except the first record.
I don' know what you expect the combo box in frmBnBDetails to do.
Personally Id allow form record navigation buttons.. but that may not be what you want to do
Well I want this form to be as intuitive as possible. A user coming in never seeing access before will not know how to navigate the records if they've never used the record navigator before. So I guess, what I'm trying to get that combo box to do is to be the "record navigator" and let the user choose the records they want (by choosing from the drop down list) and then once the record is chosen from the Combo box, the rest of the form updates with the Contacts at said Address.