The information in this article applies to:
SYMPTOMSIf a table has a primary key and you use the table in a RowSource property in a list box or combo box, you will see the data in insertion order, not primary key order. RESOLUTIONFor historical reasons of the database, the order of insertion may have importance. To view the table's contents in primary key order, design a query that sorts on the primary key. Use the query as the RowSource property for the list box or combo box. STATUSThis behavior no longer occurs in Microsoft Access version 2.0. REFERENCESMicrosoft Access "User's Guide," version 1.0, pages 21-33 and 87-114 Additional query words: listbox combobox row
Keywords : kbusage FmsCmbo |
Last Reviewed: March 11, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |