No, for a number of reasons, the major one being that there's no concept of
"previous record" in relational databases. Tables are "sacks" of data, with
the rows fitting wherever they can. If the order is important, you need to
use a query with an appropriate "ORDER BY" clause.
--
Doug Steele, Microsoft Access MVP
(No private e-mails, please)
Rob said:
Is it possible to set the default value of a field to repeat the value
from the previous record?