Go To Last Updated Record

[gnarpeggio]

Hello again,

I'm trying to figure out if I can set the OnOpen event to go directly to the last record that was edited. I know how to set it to go to the last record, next record and all that, but since I'm working with a table that has a list of preset numbers I'm hoping Access has a way to do this.

Any thoughts?

 

[boblarson]

The only way you can go to the last updated record, you will need to have a field where you save the date/time when a record is updated (you can use the form's Before Update event). Then you can sort using a query and then you can move last.

Just an FYI for you - tables don't store data first in / first out like that. In fact, they really don't, for the most part, store the data in any meaningful order whatsoever. The data goes in an available slot. You have to use a query with a sort on whatever field or fields you want in order to have ORDER.

 

[gnarpeggio]

I figured as much. I'll work on getting a sorted procedure to reorder the records.

Thanks!