refresh with code after update (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:02
Joined
May 7, 2009
Messages
19,169
I owe you an explanation.
you add bracket when your table or fieldname has space between them.
from the guys and a girl, you're welcome!
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 06:02
Joined
Feb 19, 2002
Messages
42,970
use a dLookup() in the AfterUpdate event of the "key" control to determine if that key value already exists. If it does, you can cancel the update
This was a typo. You CANNOT cancel the AfterUpdate event. Validation belongs in the BeforeUpdate events which you can cancel
 

Users who are viewing this thread

Top Bottom