Combining combobox values to one value

[DanielleN]

Dear all,

I would like to be able to combine answers from different comboboxes to 1 variable.
Let me explain the situation in my access db:
The database is a medical registration system. In this system one should identify the diagnosis. Doing this happens in 2 steps.
First you have the variable diagnosis: this is a combobox naming 8 parts of the body (general, pelvis, knee etc.)
Depending on the selection a follow up variable appears with a combobox specifying the complaint. So there are 8 follow up variables depending on the choice made in diagnosis. See image:



What I would like is make 1 variable combining the answers of the 8 follow up questions. As every case can only have 1 answer in one of the 8 variables I would assume this is possible but i do not see how. The variable is needed for the next form, the treatment form, were one can select which case the treatment is on. At the moment it looks like the image below but I would like an extra column with the specification of the diagnosis:




I hope the above is clear and someone has the solution .
Thanks in advance.
Kind regards, Daniëlle

[RuralGuy]

Not sure where you are having a problem. You should be able to concatenate the values of several ComboBoxes into one variable if you want.

[DanielleN]

Thank you for your reply. As access is a bit new to me I was not aware that I could do that. Looking it up on google showed me the trick. Thank you for the help.

[RuralGuy]

You are most welcome. Thank you for posting back with your success and solution and for marking the thread as Solved.