Combo box to choose fields

[Ruegen]

I require a combo box to requery a continuous form to swap the email field to a different email field on the same record



so

email1 email2 email3

depending on what is selected in the combo box

so

if I were to choose email2 all the email1 fields in the continous form would have their control source swapped to email2

the problem I have is making a combo box that allows me to display the three fields, email1, email2, email3 as currently they are all in the same. I'd like a customized combo box I guess...

any suggestions?

Update


Currently I am using this below but I would like to swap it for a combo box to save space

[June7]

I don't understand what you mean by 'swap'. What's wrong with showing all 3 fields and having 3 comboboxes?

A UNION query could combine all three into a single dataset for 1 combobox.

[Ruegen]

I don't understand what you mean by 'swap'. What's wrong with showing all 3 fields and having 3 comboboxes?

A UNION query could combine all three into a single dataset for 1 combobox.

hmm.. might just stick with the option group