Referencing text from drop-down vice ID number

[spudracer]

[SOLVED] Referencing text from drop-down vice ID number

I know this is simple, but I feel like Simple Jack this morning. I'm trying to take the text from a drop-down menu and use that as part of the form caption. However, the text is not what is bound, the ID number is.

I know I'm going to feel like an idiot when it finally dawns on me how to do this.

 

[pr2-eugin]

How about ?

Me.CaptionLable.Caption = Me.yourComboBox.Column(1)

Or

Me.yourComboBox.SetFocus
Me.CaptionLable.Caption = Me.yourComboBox.Text

 

[pbaldy]

Refer to the column:

ComboName.Column(x)

 

[spudracer]

I figured it out, but it wasn't either of those options. I chose to add in the field from the table that data is stored in. It works, but I never even thought about referencing a column within a drop-down.

Thanks for the assist!

 

[pr2-eugin]

Good for you !