Two columns in List box from select statement

  • Thread starter Thread starter Therese
  • Start date Start date
T

Therese

I have problems showing both values from a select statement in my list
box.

This is my query

lstArtOversiktOrdre.RowSource = "Select T_ARTIKKEL.NAVN,
T_ART_OVERSIKT_ORDRE.ANTALL From " & _
"T_ART_OVERSIKT_ORDRE, T_ARTIKKEL "
& _
"Where
T_ART_OVERSIKT_ORDRE.ID_ORDRE =" & publicVariable & _
"and T_ART_OVERSIKT_ORDRE.ID_ART =
T_ARTIKKEL.ID_ART"

The settings of the box are
ColumnCount: 2
Bound column: 1
multiple select: simple

What am I doing wrong here?
I have tried different solutions, but none of them seem to work...
I would be grateful for any help

Therese
 
Did you set the Column Widths property?
It should contain 2 values, separated, e.g.:
1"; 1.5"
 
Back
Top