<div>
<div class="content wysiwyg-content">
I have a datasheet in a subform and have in column 1 a combobox with two columns. I would like to use the value of the hidden second column of the combobox to fill in the third column of the same datasheet. However, if I use me.thirdcol = cmbCombo.column(1) then it takes the same value for all rows in the datasheet. Thank you for any help...
</div>
</div>


I have a datasheet in a subform and have in column 1 a combobox with two columns. I would like to use the value of the hidden second column of the combobox to fill in the third column of the same datasheet. However, if I use me.thirdcol = cmbCombo.column(1) then it takes the same value for all rows in the datasheet. Thank you for any help...

use combobox to fill hidden columns in a datasheet of a subform

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.