Combo Box

[toolsofministry]

Have a combo box tied to a data control which is tied to a query in an Access database. Query has 4 fields. How do you store the value of a field that is not the bound column to a variable using VB code.

 

[CCLINT]

Say you want the 2nd field called: myFieldName2

Then:
myVariable = DataControl1.Recordset("myFieldName2&quot

Or,
myVariable = DataControl1.Recordset(1)

(using the number 1 instead of 2 because the base is zero. So Recordset(0) is the first field, and Recordset(1) is the second field, etc.) [/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[vb6novice]

It appears that you are saying that the record selected in the combo box becomes the current record in the Data Control. Is that correct?

 

[CCLINT]

vb6novice: It the combo is truely and corretcly bound to the data control, then yes.... [/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}