If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Records in Listbox Identified in Reverse Order
Hello,
I have a list box that is populated as data is entered into the form. (I'm reusing a database that worked well, but needed editing for a different project.) In the original database, the records were identified correctly--first item entered is record 1, second item entered is record 2,... In the "new" database (I had to modify some data sources), the items are in reverse. The first item entered is record 2, the second item entered is record 1,... Any idea why this is occurring? I've checked what I know to check and cannot tell what the problem is. Thank you, |
#2
|
|||
|
|||
Records in Listbox Identified in Reverse Order
Hi -
Please give us more information - What is the row source type for your listbox - table/query or value list? How are you adding values to the listbox - if VBA, please post the code. Thanks John Londa Sue wrote: Hello, I have a list box that is populated as data is entered into the form. (I'm reusing a database that worked well, but needed editing for a different project.) In the original database, the records were identified correctly--first item entered is record 1, second item entered is record 2,... In the "new" database (I had to modify some data sources), the items are in reverse. The first item entered is record 2, the second item entered is record 1,... Any idea why this is occurring? I've checked what I know to check and cannot tell what the problem is. Thank you, -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200911/1 |
#3
|
|||
|
|||
Records in Listbox Identified in Reverse Order
Access stores records like a barrel of brick - just a jumble, no set order.
Do not view records at the table level but use a query, form or report. These can be sorted in any manner that you need to display. -- Build a little, test a little. "Londa Sue" wrote: Hello, I have a list box that is populated as data is entered into the form. (I'm reusing a database that worked well, but needed editing for a different project.) In the original database, the records were identified correctly--first item entered is record 1, second item entered is record 2,... In the "new" database (I had to modify some data sources), the items are in reverse. The first item entered is record 2, the second item entered is record 1,... Any idea why this is occurring? I've checked what I know to check and cannot tell what the problem is. Thank you, |
Thread Tools | |
Display Modes | |
|
|