autofill textbox based on combo box value

[zambam]

i know this must be very simple, pls forgive me - i just cant figure it out.

i have a combo box which displays the ''products''.

i also have a text box which will display the products ID.

i need the text box to display the ID of the currently selected product in the combo box.

how would i do this?

pls help ive been trying to figure out for ages but no luck.

thanks

 

[rainman89]

if the bound column of the combo box is the id then

=me.comboboxname.column(0)

i might be off on that.. but its either 0 or 1.. end of day and brain is fried....

 

[zambam]

lol thanks but i didnt understand any of that...

 

[rainman89]

in the afterupdate event of the combo box set the txtbox value to
me.comboboxname.column(0)

me.txtboxname=me.comboboxname.column(0)

 

[zambam]

thanks it worked!