Selection from combo box (1 Viewer)

[emsadoon]

I have an unbound combo box with three columns, which get the values from a query. The first column is hidden. When I close the combo box after my selection, only the second column value is shown on the box. Is there any way that both the second and third column being shown on the box after selection?

 

[missinglinq]

That's the way Comboboxes work. You can add a Textbox to display the third column, using code like this

Private Sub ComboName_AfterUpdate()
 Me.TextboxName = Me.ComboName.Column(2)
End Sub

Or you can modify your Query/SQL Statement to concatenate the second and third columns into a single Field.

Linq ;0)>

 

[emsadoon]

Thanks, I used concatenate method, which I did not know before.

 

[missinglinq]

Glad we could help!

Linq ;0)>