How to set textbox value to same as one in combo box

[behnam]

Hi uys,



I want to set the textbox value of Text282 to the value selected in a combo box (Combo912).

I tried

Text282=Combo912

but its giving me numberical numbers not the string itself. I also tried

Text282=Combo912.value

but get the same outcome.

thanks for your time

[June7]

The value of combobox is whichever column is set in the BoundColumn property.

Does the combobox RowSource include an ID field? Is this the BoundColumn? You are saving the ID into record? Should not be saving the alias text. Display the alias in textbox ControlSource with an expression: = [Combo912].[Column](x)

x would be the column index, which begins with 0. If the alias is in column 2 the index is 1.

[ranman256]

Text282=Combo912 is correct, so you may have the combo's bound column set to the number, not the name column.


FYI, you can rename these so they make sense, like cboName, or txtLastName. (but it must be done before all the programming is done)

[behnam]

Thanks both of you!!!