<div>
if you want to get the value from the second column of the combo box, use the afterupdate event of the combo box<br />
<br />
private sub combo0_afterupdate()<br />
<br />
me.textbox1=me.combo0.colu<wbr />mn(1)<br />
<br />
end sub<br />
<br />
you also need to set the column count of the combo box to at least 2, assuming the rowsource of the combo have two columns<br />
<br />
<br />
post the rowsource of the combo box if you need more help<br />
<br />
<br />
<br />

</div>


if you want to get the value from the second column of the combo box, use the afterupdate event of the combo box

private sub combo0_afterupdate()

me.textbox1=me.combo0.column(1)

end sub

you also need to set the column count of the combo box to at least 2, assuming the rowsource of the combo have two columns


post the rowsource of the combo box if you need more help





dainty.mdb

<div>
Thanks a lot Nick67!!! &nbsp;This was very easy to follow...you hit the nail on the head!!!
</div>


Thanks a lot Nick67!!!  This was very easy to follow...you hit the nail on the head!!!

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have been unsuccessful in trying to follow the code in the related thread to update the value in my form's textbox field based off of the selected value in the form's combo box field. &nbsp;When I implemented the code from this thread, it compiles fine, however all it does is places the select statement in the textbox field on the form when I run it. &nbsp;Any help is greatly appreciated...please tell me what I need to do differently?<br />
<br />

</div>
</div>


Hi Experts,

I have been unsuccessful in trying to follow the code in the related thread to update the value in my form's textbox field based off of the selected value in the form's combo box field.  When I implemented the code from this thread, it compiles fine, however all it does is places the select statement in the textbox field on the form when I run it.  Any help is greatly appreciated...please tell me what I need to do differently?



How to update text field on access 2007 form based off of value chosen in combo box on the same form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.