Apr 25 2005, 09:09 AM
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 ??
Apr 25 2005, 09:16 AM
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.
Apr 27 2005, 07:26 AM
I've read thru your suggestion several times and not clear on how to accomplish this. Is there an easier way ?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here