SOLVED

Combo Box - Reference a hidden field

%3CLINGO-SUB%20id%3D%22lingo-sub-2095549%22%20slang%3D%22en-US%22%3ECombo%20Box%20-%20Reference%20a%20hidden%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095549%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3A%3C%2FP%3E%3CP%3EI%20have%20a%20combo-box%20on%20my%20Access%20form%20with%20two%20fields%3A%26nbsp%3B%20A%20Product%20ID%20and%20a%20Product%20name.%26nbsp%3B%20I%20hide%20the%20ID.%26nbsp%3B%20How%20can%20I%20reference%20the%20combo%20box%20hidden%20ID%20in%20VBA%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2095549%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello:

I have a combo-box on my Access form with two fields:  A Product ID and a Product name.  I hide the ID.  How can I reference the combo box hidden ID in VBA?

Thanks,

1 Reply
best response confirmed by richlocusoutlookcom (New Contributor)
Solution
Me.ComboboxName

It will return the bound column value.