.OLDVALUE display previous record value

[smsmail]

Hi Again,

I have a button that will allow the user to email a recipient, indicating what fields where modified on a bound form. (i.e. me.control.oldvalue)

My me.mycontrol.oldvalue displays the old values of the previous record, not the current record.

I think it does so, because my code uses sql code to obtain the record based on the user' selection criteria.

How can I get the current record's ".oldvalue" to display?

Can I re-initialize the form?

Thanks for your help.

 

[vbajock]

http://msdn.microsoft.com/en-us/library/aa172955(v=office.11).aspx