Melt info from 3 comboboxes into 1 box or bookmark

Jazzcrime · Guest

hi people!

I currently breaking my head over an issue, i could use some help!

- i have 3 comboboxes: combobox1 (list of country's), combobox2 (list of
company's), combobox3 (list of city's)

every possible combination of value's from comboboxes have a code.

my question:

what is the easiest way to get this done? their are 5 value's in combobox1,
3 value's in combobox2 and 6 value's in combobox3.

combobox1.value & combobox2.value & combobox3.value = combobox4.value

the thing is, combobox4.value = has not to be the value's from combobox
1/2/3 but a code that is decided by the value of combobox1/2/3. this value is
a code that is decided already by my boss, so it cannot be random.

for example:
Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Londen
Combobox4 = 12345

or

Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Manchester
Combobox4 = 55554

my english is not very good, i hope u understand my problem!

kind regards,

Google · Sponsor

Helmut Weber · Guest

Hi Jazzcrime,

hmm...

Tony Strazzeri · Guest

Hi Jazzcrime,

Presumable each value in each combobox has a code. Where is that
stored?

You could store the code in a second column of the combobox and then
extract that column to generate the value for combobox 4.

But why have a combobox4 at all if the value for is calculated based
on the other items?
There will only be one value for each combination of the other
comboboxes

Cheers
TonyS.

On Dec 20, 12:16 am, Jazzcrime <Jazzcr...@discussions.microsoft.com>
wrote: