Copying text from one field to another

OK so I have these three Combo Boxes.  CBO1, CBO2 and CBO3.

All three boxes have the exact same listings in them.  Designators.  (A person can have up to three designators in the App.)

What I would like to try and do is this:

Let's say the CBO1 box has the designator 'SW' in it and CBO2 and CBO3 say 'NONE'
Now I select 'IDW' as the designator for CBO2 and leave CBO3 with 'NONE'

What I would love for the app to do is this:

If the IDW designator is choosen in CBO2 or CBO3 it automatically puts it in the CBO1 box and what was in the CBO1 box is moved to the CBO2 box and what was in the CBO2 box get's moved to the CBO3 box.

I am sure this will need to be in the afterupdate event for all three boxes I'm just not sure how to make something like this happen.  If it's possible.


John SheehySystem Security ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
"If the IDW designator is choosen in CBO2 or CBO3 it automatically puts it in the CBO1 box and what was in the CBO1 box is moved to the CBO2 box and what was in the CBO2 box get's moved to the CBO3 box."

This is one of those questions where you need to consider all the contingencies, and what you want to happen for each...
For example suppose CBO1 is empty when you select "IDW"
Or if IDW is in all three already
John SheehySystem Security ManagerAuthor Commented:
The default value for all three fields is 'NONE'  So if IDW is choosen as the one choosen in CBO1 and it was none orginially then nothing would need to happen.

The reason we need this to happen this way is the Command we are at the primary designator is IDW all others are secondary and triciary.  Now if someone coming from a ship has the designator SW or AW and that's all they have then CBO1 and CBO2 would be SW and AW.  But if they earn the IDW here that designator becomes the priamry, SW and AW become second and third.  Make sense?
Jeffrey CoachmanMIS LiasonCommented:
Just a bit more info requested...
If these comboboxes represent the Primary, Secondary and Tertiary ranks, ...
The why aren't these users entering their rank in the appropriate combobox?

In other words cbo1 should only allow the highest ranks to be selected
CBO2 should only allow the secondary ranks
CBO3 should only allow the Tertiary ranks...

,,,in other words IDW, should only be an Option in CBO1...
...Am I understanding this correctly?

...and to be clear, what you are asking for here can be done exactly as you request, just seems like a lot of logic is involved just to put selections where they should be in the first place...

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Look at sample. But I argee with Jeff (boag2000) - you should carefully check logic and investigate all possible combinations

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John SheehySystem Security ManagerAuthor Commented:
If they were ranks it would be that easy.  They are special designators that are earned.
Not all commands offer the same designators.  Example I can earn IDW at this command but I can not not earn SW here.  Where if I went to a destroyer I could earn SW but not IDW.  I will look at the sample and see how that works.  Thanks.
John SheehySystem Security ManagerAuthor Commented:

Your sample is exactly what I need it to do.  Thank you very much.

Jeffrey CoachmanMIS LiasonCommented:

Thanks for helping out again here, ...lets see if your sample is what they were looking for...


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.