I have a combo box that I would like to populate with multiple fields from the same record and have it properly update when the user changes the value in another combo box.

In other words, the rowsource should be the values of contact, contact2, contact3, and contact4 of the currently selected record. Then when the user selects a different custid in another combo box, the rowsource would update to properly reflect the values from the same contact fields for the new customer.

I'm not sure how to approach that one. What's the best way to handle that?

Thank You.