Default Field Value = Field Value in Prior Record

[akt01]

Hello. I am looking for a way to make a field value automatically default to
the value of the immediate prior field. For example, I am in record 11, and
in Field "City" I type "New York." When I create record 12, I want
City to automatically default to "New York." Is there a way to do this?

Thanks

 

[RuralGuy]

I believe the following link details a pretty good solution to your situation. How to fill record with data from previous record automatically in Access 2000

 

[Oldsoftboss]

Making the next field in records default to the last record.


In the After Update event of the UserID field put code like this:
Me![UserID].Tag = Me![UserID].Value
In the On Enter Event of the same field put code like this:
If Not Me.NewRecord Then Exit Sub
If Not (IsNull(Me![UserID].Tag) Or Me![UserID].Tag = "") Then
Me![UserID].Value = Me![UserId].Tag
End If
The UserID will not carry over into your next session with the form but will work as long as the form is open....