Field default value

[Lance R Peck]

How can I make a field of a new record on a form default to the value of the same field of the previous record (automatically)?

I want the field data to repeat until it is chaned by typing in new data, then the new data becomes the default until changed.

 

[Travis]

Here is an Idea:

Private Sub Form_Current()
'Make sure field does not have data
If isNull(me.[Field1] ) then
Me.RecordSetClone.BookMark = Me.RecordSet.BookMark
Me.RecordSetClone.MovePrevious
me.[Field1] = Me.RecordSetClone.[Field1]
End if
End Sub