Thanks for the responses.
Rick_R wrote on Mar 8
th, 2012 at 9:18pm:
Check XLookupAll(). It returns all matches as a semi-colon delimited string, i.e., essentially:
Manufacturer = "ABC-Company"
AllModels = xlookupall(Manufacturer, "Products" [etc])
AllModels will come back as "ABC123;ABC345;ABC456"
Then the combo box options can be populated using that string.
This is the approach I tried. However, tabbing to the next combo box apparently doesn't trigger any event (or at least none that I can determine), so the combo box never gets populated. I'm so used to navigating through data choices in this manner using arrows to select a choice, then tabbing to the next combo box, selecting another choice, tabbing, etc..
Rick_R wrote on Mar 8
th, 2012 at 11:22pm:
I think which approach to use would depend on how many items there are in each category and how often the items change. Either way, your PopulateListElement code would be used whether it is a static list or whether the list was obtained by xlookupall.
Also, depending on the product, a static list may be the best approach for one box (e.g., Size) and xlookup might be best for another, e.g., Model [style number] if the product is clothing.
This is correct. Size is a small static list of predefined values, but Model + Manufacturer + Length is a possible range of many thousands. I just wish I could get the combos to populate after tabbing.