Combo box help

[Neekos]

i have a combo box whos row source is being populated by a choice made in another combox box using the following code:

Private Sub Balcony_Category_AfterUpdate()
If [Category].Value = "Inside" Then
    Me.CategoryNum.RowSource = "SELECT tblCabins.InsideCat, tblCabins.InsideCatB FROM tblCabins WHERE tblCabins.GroupNumber = '" & Me.GroupNumber & "'"
ElseIf [Category].Value = "OV" Then
    Me.CategoryNum.RowSource = "SELECT tblCabins.OVCat, tblCabins.OVCatB FROM tblCabins WHERE tblCabins.GroupNumber = '" & Me.GroupNumber & "'"
ElseIf [Category].Value = "Balcony" Then
    Me.CategoryNum.RowSource = "SELECT tblCabins.BalCat, tblCabins.BalCatB FROM tblCabins WHERE tblCabins.GroupNumber = '" & Me.GroupNumber & "'"
ElseIf [Category].Value = "Suite" Then
    Me.CategoryNum.RowSource = "SELECT tblCabins.SuiteCat, tblCabins.SuiteCatB FROM tblCabins WHERE tblCabins.GroupNumber = '" & Me.GroupNumber & "'"
End If
End Sub

This works, but i want the output to be in a single column form, instead of two. Is this possible?

[Rabbit]

What do you mean? Concatenate the two columns?

[Neekos]

yes. right now it looks like this:

A B C

and you cant select just A or just B or just C.

i want it to be like so:

A
B
C

so that you can select them individually.

[Rabbit]

You're looking for a union query.

[Neekos]

Yes! thank you my friend!

[Rabbit]

Not a problem, good luck.