How to store values temporarily

[Naveen Marapaka]

Dear I stuck in small issue.


I dont want to make my issue so confusing, so if below is solved then this solution can lead to major change in my program.


I have a subform and with some fields
and one of the Textbox field name is Intranet_No

a command button in main form just to show popmessage of the text entered in Intranet_No

Example Initially My Intranet_no has ABCDEF so when i click button PopupMessage will be ABCDEF

Now I will edit my Intranet_No as DECDGL so now if i click button i want 2 popupmessgaes with before and after

like Before ABCDEF
After DECDGL

what should be my code to get this

how to store ABCDEF previous value


currently i have below

private sub Commandbutton_click()

Dim A1,B1 as string

Set A1 = Me.Details.Form!Intranet_No

msgbox A1

End sub

[pbaldy]

If the form is bound, Access is already storing the value for you, until the user saves the record.

Msgbox Me.TextboxName.OldValue

Returns the value before editing.

[ssanfu]

Also, you have A1 declared as a Variant and B1 declared as a String. If you want both A1 and B1 declared as strings, you have to use

Dim A1 As String, B1 As String

[Naveen Marapaka]

Dear I did the same Msgbox Me.TextboxName.OldValue
but still the msgbox display the current value of the textbox.

all subform fields are bound to table , so what ever i am editing it is directly updating in table.

I require to get the previous Value before editing

how can i get it

[pbaldy]

Where do you have the code? I just tested and it worked as expected. You have to be running it before the form updates.

[Naveen Marapaka]

Code is in command button click event.

private sub Commandbutton_click()

Dim A1,B1 as string

Set A1 = Me.Details.Form!Intranet_No

msgbox A1

End sub

[pbaldy]

Dear, I don't see OldValue anywhere.

[Naveen Marapaka]

Dear even if i am using Me.Details.Form!Intranet_No.Oldvalue as well.

still the result is what is currently showing in text field it is displaying in msgbox.

I just need to store virtually my previous text and show me in msgbox after I edit to new text.

kindly advise.

[pbaldy]

It worked when I tested it. Can you post your db?