Remember A Value .Is it Possible

[mkkashif]

Hello Dear Sir.
i want if a customer enter a value in a Text Field.Then if we go to new Record.
In That Text Field The Last Value we enter last time Automaticaly Shows.
is it possible.to show the last value next time in new record.
Any Help will greatly appreciated

 

[Mile-O]

At form level, dimension a variable. I'll assume it's a text value you want.

Dim strValue As String

In the AfterUpdate event of your textbox, use the following code:

strValue = Nz(Me.MyTextBox)

In the form's Current event, use the following code:

If Me.NewRecord Then Me.MyTextBox = strValue