Update from 1 field to another in same table

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

This may seem like a very easy question, but it's got me
stumped. I want to update a field called OldMaster with
information from a field called MasterID. Both fields are
in the same table called Communication. This update
occurs before the MasterID is changed to a new MasterID
number by a user. Perhaps I am thinking too complicated
hard about this and making it more complicated than it
really is, but I can't seem to figure this one out.
Thanks in advance
 
There may be an easy way, but you could set up a non bound textbox where
the new number is entered, then as an exit control event first update the
old field with the existing number in the new field and then update the new
field with the value in the control.
 
how about putting this code in the BeforeUpdate event of the form

if Me.MasterID <> Me.MasterID.OldValue then
Me.OldMaster = Me.MasterID.OldValue
end if

Hope this helps
 
Back
Top