After Update one time only?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

I have two fields; a "Name" field and a "Received as" field. When the name
is entered, it populates the "Received as" by an after update event
(Me!Received_as=Me!Name). I want to retain the original name, even though I
may change the "Name" field from time to time. Is there any way for the
After Update to run only once per record?
Thanks for any input
 
Kyle said:
Hi;

I have two fields; a "Name" field and a "Received as" field. When the name
is entered, it populates the "Received as" by an after update event
(Me!Received_as=Me!Name). I want to retain the original name, even though I
may change the "Name" field from time to time. Is there any way for the
After Update to run only once per record?
Thanks for any input
Click to expand...

If Len(Nz([Received as],"")) = 0 Then
(your current code)
End If
 
Back
Top