Re: How do I access a field in a previous record? (Access 2997)
There is no such concept as a 'previous' record, because in databases,
things aren't necessarily stored in the order you think they are.
If you want to get at a particular record, then you need to create a query.
You haven't specified where or how you want to get this record, so it's
pretty hard to give you a contextualised answer, but generally, create a
query.
SELECT x, y, z FROM tblTable WHERE somefield = somevalue
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
"stanleypatkan" wrote in message
news:7E02D975-79BD-4E08-B5B2-1B7754D87786@microsoft.com...
>
> --
> Sister Patricia Stanley CSJ
date: Tue, 8 Jul 2008 09:52:48 +1000
author: Graham R Seach
