How To Reference Hidden Field in Combo Box using VBA

Rich Locus 61

Hello:
I have an Access form with a combo box. It has two fields, a product ID and a Product name. The Product Id is hidden from the drop-down. How can I access the hidden field using VBA?

Thanks,
Rich Locus

AlphonseG 191 Reputation points

2021-01-26T00:02:59.673+00:00

<yourcombo>.Column(0) if it's the first column.
<yourcombo>.Column(1) if it's the second column.
Rich Locus 61 Reputation points

2021-01-27T01:38:53.207+00:00

Yes!! Column(0) and Column(1) is the correct answer!! Thanks.