Thank you very much Albert, it is working perfectly. Many thanks.
"Albert D. Kallal" wrote:
because I want to record the initial value of field1 before its value
changes
).
my code was
Private Sub Form_Current()
Me.field2.value = Me.field1
End sub
I don't think we need the above in the on-current event. I mean just using
the page up/down or browsing reocrds is going to cause that code to run...
I would think we ONLY want that code to run when you actually are modifying
the contensts of field1.
So, in field1 AFTER UPDATE event which ONLY fires if you made changes, you
would go:
me.Field2.Value = me.field1.OldValue
Using the on-current event fires all the time...even when you don't
edit/modify anything in the record.....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada