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"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Therese" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

Thanks a lot for your answer, now it is fixed

Thanks a lot for your answer, now it is fixed