concatenated textbox value based on combo box selections

[jle0003]

I have a form with 3 combo boxes that have several options. On that same form, I have a textbox that I would like to autofill with the selected options from the combo boxes.

For example:


cbo1Options: 1;2;3
cbo2Options: a;b;c
cbo3Options: A;B;C

Let's say the user selects 2, c, and A from the 3 combo boxes. I would like the textbox on that form to display: "2 c A".

I tried doing a query, but that just autofilled the textbox with ALL the options available in the combo boxes, not the selected ones.

Any help would be greatly appreciated!

Thanks!

[TG_W]

You can do an afterupdate after the third box is updated with code like below. Or you can do the update for all 3 in case you grab the wrong option by accident.

Private Sub cbo3Options_AfterUpdate()
Me.Yourtextbox = Me.cbo1Options & " " & Me.cbo2Options & " " & Me.cbo3Options

[jle0003]

That worked perfectly. Thank you so much!!

[TG_W]

Glad I could help. Don't forget to mark the thread as solved.