Is there a way to have the database default a field to a value above it? example

Field 1 Field2 Field3
__0001 ABCD Jay
__0002 EFGH Jay
__0003 IJKL _____

I would want my record in field 3 to look at the blank and put in Jay for me?
is this possible?
thanks in advance
Jaime

You are making the mistake of thinking of a table as if it were a spreadsheet. Row order has no meaning in a relational table and is entirely a function of the order by clause used to produce any given recordset. I can't tell from your question but it is possible that your tables are not properly defined and that the repeating data actually belongs in a "parent" table.

If you search the archives, you should find code that copies values from the "previous" record. You can also find suitable code on the Microsoft knowledge base.