Welcome to SPN

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

Sign Up Now!

List Box Wont Sort

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

Tags:
  1. ibeetb

    ibeetb
    Expand Collapse
    Guest

    I have a table with values and the table is sorted Ascending. I then have a
    form with a list box and it pulls it values from this table. The values in
    the list box on the form wont sort yet they are definitely sorted in the
    table. How can I get the list box to sort the way I have it in the table it
    is getting its vaoues from?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News How The Left & Indian Nationalists Distorted The History Of Sikh Gadhar Movement - Breaking News Sep 21, 2016
    Interfaith Materialists And Its Discontents Interfaith Dialogues Jun 10, 2016
    Sikhi Quasi-Pragmatists And Quasi-Spiritualists, Care To Explain? Sikh Sikhi Sikhism Jun 6, 2016
    Cholesterol Is Finally Officially Removed From "naughty List" Health & Nutrition Feb 11, 2016
    Listening to Gurbani while driving?? Sikh Rehat Maryada Jan 13, 2016

  3. ginnyk

    ginnyk
    Expand Collapse
    Guest

    ibeetb wrote:
    > I have a table with values and the table is sorted Ascending. I then have a
    > form with a list box and it pulls it values from this table. The values in
    > the list box on the form wont sort yet they are definitely sorted in the
    > table. How can I get the list box to sort the way I have it in the table it
    > is getting its vaoues from?


    Use a query instead of the table to fill your list. In the query, set
    the sort you want.
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 14 Jun 2006 16:08:30 -0400, ibeetb wrote:

    > I have a table with values and the table is sorted Ascending. I then have a
    > form with a list box and it pulls it values from this table. The values in
    > the list box on the form wont sort yet they are definitely sorted in the
    > table. How can I get the list box to sort the way I have it in the table it
    > is getting its vaoues from?


    Create a query using the table.
    Sort the query.
    Then set the Rowsource of the list box to that query.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page