2 fields in combobox, how to access one of them ?

[nebon]

hallo there , I have a combobox build upon a query, with 2 fields inside , how can I access one of them ? thnx in advance

 

[dcx693]

Do you mean that you have a combo box with 2 columns in it? If so, use this syntax to access the first column if you are writing code in the form's module:
Me.cboBox.Column(0)
and this to access the second:
Me.cboBox.Column(1)

 

[nebon]

yes thats exactly what I meant , thnx alot for the help .

 

[nebon]

but where do you specify the combobox name ?

 

[Pat Hartman]

Replace MyComboboxName with the control name of your combo box.

Me.MyComoboxName.Column(0)

 

[nebon]

thanks its working now .