I have a form that populates based on what the user selects in the Combo Box under [CompanyName]. Problem occurs when a Company has more than one location. For example one in Boston and one in Dallas. Boson being the first on the list will always populate the form even when the user selects Dallas.
How do I fix this ??

This combobox is a Location combobox, rather than Company combobox.

Let The combobox have two columns : Location and Company Name

In the combo AfterUpdate event, use the bound column zero to search for Location.

I've read thru your suggestion several times and not clear on how to accomplish this. Is there an easier way ?