I have a combobox from which the user can select a list of customers. In this list, I have a hidden column - column 6 - that stores the primary key for that customer. I set the BoundColumn property of the combobox to 6, because once the user selects a customer I want to store the primary key to a variable.
In the interactiveChange event for the combo box I have then entered this code:
myVar = this.value()
expecting that my hidden "BoundColumn" would be the value that is returned. But instead I keep getting the cryptic error:
Invalid Subscript Reference.
Any ideas on what I'm doing wrong? Thanks.