Textbox showing ID instead of value

[David Ball]

Hi,

I have a Form where I can select car characteristics such as Make and Model from Comboboxes to create a record for a particular vehicle. This works fine.
I also want to show the Make at the top of the form in a Textbox, however, rather than showing Ford, for example, it shows the ID number instead.
How can I get the Textbox to show the Make of the vehicle instead of the ID associated with that make?

Thanks very much
Dave

 

[GinaWhipp]

If you are pulling the Make from the Combo Box...

=[YourComboBoxName].[Column](1)

(1) being the second column of your Combo Box and the column that has the Make in it. If not change the number accordingly.

EDIT: Oops, forgot to tell you to place the above on the Control Source of the Text Box.

 

[arnelgp]

use the Current of your form and AfterUpdate event of the combo:

private sub form_current()
me.unboundtext=combo.column(1)
end sub

private sub combo_afterupdate()
call form_current
end sub