refering to combobox in code

[teiben]

Help! I have a combobox combo22, which via SQL is hooked to tblMachineType w/many records for look up purposes.

combo22 rowsource is
selectdistict statement to SELECT DISTINCTROW tblMachineType.MachineTypeID. Its bound on the ID. The form displays the field type. This works great! but how would I get the value (not the ID) to show up in a textbox, I can only get the IDto show up.

ControlSource: ID
Name: Combo22

I've tried combo22.Column(2) and combo.ID; help

 

[pbaldy]

It would be

Me.combo22.Column(2)

But keep in mind the Column property is zero based, so 2 would be the 3rd column.

 

[teiben]

that doesn't work, any other ideas?

 

[pbaldy]

What is the rowsource of the combo and the number of columns setting?

 

[teiben]

Got It

Thank you, Thank you, Thank you