Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116

    Unanswered: Combo box not sorted

    I have a form with a combo box which is from a table. The table is sorted by the field used in the combo box, but whenever I click on the combo box the data is not sorted. How can I make this sort?


    Thanks . . . texasalynn

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    If you haven't done so already
    1) Set the Row Source Type for the combobox to Table/Query
    2) Type an Sql statement like this in the row source:
    Select field1, field2

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Sorry, my PC took a vacation a minute ago...
    Anyway.... As I was saying
    If you haven't done so already
    1) Set the Row Source Type for the combobox to Table/Query
    2) Type an Sql statement like this in the row source:
    Select field1, field2
    from table1
    order by field1

    That should do it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •