J
Joyce O
In my database I have a field for "CaseType". I have many
reports and forms that reference this field and all is
working great. Recently we have noticed that
the "CaseType" entered is many times incorrect and needs
to be revised. I'm all set with updating my table with
the new revised CaseType, but here is where I have a
problem. I would like to keep track of
the "PreviousCaseType" for training purposes. How can I
get Access to automatically move "CaseType" to
the "PreviousCaseType" field when my Revise Case Form is
launched (I only want the field of "PreviousCaseType" to
populate when the case type is actually revised). My
thoughts were that I could use code to accomplish this on
the On Open property, but I'm not sure how to write the
code. Any help you can give is appriciated, thank you
reports and forms that reference this field and all is
working great. Recently we have noticed that
the "CaseType" entered is many times incorrect and needs
to be revised. I'm all set with updating my table with
the new revised CaseType, but here is where I have a
problem. I would like to keep track of
the "PreviousCaseType" for training purposes. How can I
get Access to automatically move "CaseType" to
the "PreviousCaseType" field when my Revise Case Form is
launched (I only want the field of "PreviousCaseType" to
populate when the case type is actually revised). My
thoughts were that I could use code to accomplish this on
the On Open property, but I'm not sure how to write the
code. Any help you can give is appriciated, thank you