Access VBA
If I have an integer variable based on a value from a combo box and that value consists of two columns, both integers how to decide which one to take?
RE: Access VBA
Hi Fabian
Thanks for your question
I am assuming that you are selecting a value in a multicolumn combo box and assigning the value of that combo box to a variable.
If this is the case then the value of the combo box is always the first (left most) column in the combo box. The other columns are there to clarify the identity of the field to the user.
Thus, which ever column you wish to return must be set as the first column
Regards
Stephen