>Can anyone think of a simple way to grab a value from a field in the record immediately before and after the current record, without changing the current record? It has to respect the sort order as well.
>
>It seems like it should be simple, but it's just not coming to me...
>
>Thanks,
>
>Michelle

Why don't you want to move the record pointer? If you are using Optimistic Table buffering, it shouldn't matter.