Populate a Textbox/Label Using SQL?

[nevadaflyfisher]

I have a combobox on a form that's poulated with values from column 1 of a table. I'd like to include a disabled textbox or label on the form that displays the column 2 value on the combobox's On Click event.

Many Thanks in Advance,
Ken

 

[smedvid]

I usually have the field in the combo box dropdown list... Either set width to zero to hide or actually display it.

Then display in text box as follows on the OnChange Event of the Combo box.

Me.txt_User_Group.Value = Me.cbo_UserGroup.Column(2)

htwh,

Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[nevadaflyfisher]

Thank you very much for the quick reply, Steve. It works perfectly!