Auto Label Text 1

[Dilly]

I have created a form and in the form there is a combo box for selection of either number 1 or number 2. I want to create a label or text box that will be filled in by the selection of one of the numbers.

I want it to put text "UK" for the number 1 and "Overseas" for the number 2.

 

[gusbrunston]

I assume that your combo box looks like this:

1 | UK
2 | Overseas

In the After Update property of your combo box enter this code:

Private Sub cboUKorO_AfterUpdate()
    Me.txtUKorO = Me.cboUKorO.Column(1)
End Sub

"txtUKorO" is the text box you want the choice to appear in. "cboUKorO" is the combo box in which the choice is made.

"Column(1)" if "UK" and "Overseas" appear in the second column of your combo box. Count starts from left to right at "0".

I hope this works for you.
Gus Brunston
An old PICKer
padregus@home.com