Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

using multi column listboxes on access form - only shows one row?

Discussion in 'Information Technology' started by Angus Comber, Jul 28, 2006.

  1. Angus Comber

    Angus Comber
    Expand Collapse
    Guest

    Hello

    My rowsource in my 5 column listbox is:

    SELECT StartDate,Companyname, PolicyName, SellingAgent, ClientComments FROM
    Policy WHERE ClientID = lblClientID.caption

    It works - but only shows 1 column. Even though have two rows in table with
    this ClientID.

    What am I doing wrong?

    Angus
     
  2. Loading...


  3. Angus Comber

    Angus Comber
    Expand Collapse
    Guest

    OK I have sorted - stupid mistake.


    "Angus Comber" <nospam@gmail.com> wrote in message
    news:#HdAcULrGHA.1848@TK2MSFTNGP02.phx.gbl...
    > Hello
    >
    > My rowsource in my 5 column listbox is:
    >
    > SELECT StartDate,Companyname, PolicyName, SellingAgent, ClientComments

    FROM
    > Policy WHERE ClientID = lblClientID.caption
    >
    > It works - but only shows 1 column. Even though have two rows in table

    with
    > this ClientID.
    >
    > What am I doing wrong?
    >
    > Angus
    >
    >
     

Share This Page