VBA ComboBox SetItemData type feature?
In this case, I want to retrieve company names and their associated ID's
from the a database. It is a lot cleaner to be able to do other queries
based on the ID, because I can get to other tables directly. Example:
ask for all employees in a company by ID--the company name, of course,
isn't in the Employee table).
I think I've figured out my answer: you use multicolumns and put your
data in one of the columns, then hide it. Not too great, but it'll work
(I think).
Seems like people would run into this problem all the time.
What exactly do you want to retrieve? The combobox has a Listindex which
maybe you could use.
|