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
