Updating/Viewing records in ACCESS

[logo]

I have written a VB application which reads/writes records to ACCESS 2000. The table is indexed via a date/time field. When I "movelast", "addnew", "update", then "moveprevious", I expect to see the record which I have just entered. . . However, the record which I just entered is placed somewhere in the middle of my table?!

I'm not sure what is going on. The only field I have indexed is my date/time field. If I open Access and look at the table, it appears that my record was appended to the end of the table, but when I actually navigate through it, Access odviously orders it differently. For some reason it is telling me that entries entered on the 18th came before entries entered on the 14th?

Any thoughts or ideas??

 

[gwinn7]

Seems to me that it has nothing to do with your field being indexed, but how your recordset is sorted. If you have a "requery" command, that will for sure re-sort your recordset and produce the results you are getting. In other words, one item to check is "Requery" and check the "ORDER BY" clause in your SQL.

Hope that helps.

Gary
gwinn7