on activate command

[Jason]

In my database I need to create a form that I can revise
the case type of a record. I want to retain the original
case type before it is revised. Im thinking the best way
to do this is when the Revise Case Type Form is activated,
copy the "CaseType" data to the "OriginalCaseType" field
and lock that field so it can not be editted or changed.
Then the user can change the "CaseType" to what they
want. Will that work and what is the code for copying
the "CaseType" to "OriginalCaseType" on the On Activate
property? I appriciate your help, thanks

 

[Michel Walsh]

Hi,



I would just use Me.ControlName.OldValue. OldValue keep the last
validated (committed) value in the RECORD (last time the record was saved,
with success), or since you open the form (if you didn't change the control
for this record since you open the form).


Hoping it may help,
Vanderghast, Access MVP