Avatar of John Sheehy
John SheehyFlag for United States of America asked on

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.

Thanks

John
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Jeffrey Coachman

"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
...etc
ASKER
John Sheehy

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 Coachman

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, ...it just seems like a lot of logic is involved just to put selections where they should be in the first place...



JeffCoachman
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
John Sheehy

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.
ASKER
John Sheehy

als315,

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

V/r
John'
Jeffrey Coachman

als315,

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

;-)

Jeff
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.