Keep the previous value after creating a new record

[mmaarof]

Hi..

I'm new here..I want to know how to keep previous data/value after creating a new record.

[lfpm062010]

This is one way.

Create a SAVE/BACKUP table to store those previous data/value.

[Missinglinq]

Your goal here is a little fuzzy, from your post, but if you're saying that you want to enter a value in one Record, then have that same value automatically entered in subsequent New Records, you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

You’ll need to do this for each Control that you want to ‘carry forward.’

Linq ;0)>