Update from 1 field to another in same table

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
 
B

bobby

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update from 1 field to another in same table 1
Update table field by content in another field in the same table 2
Macro required for moving data between tables in specified format 10
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
VBA Reference to Fields in Tables 9
Update a field from one table to another? 2
Visio 2010 - Deleted shape data fields not disappearing 1
Add Days from another table to Date in current table 4

Top