arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 04:25 Joined May 7, 2009 Messages 20,302 Aug 17, 2019 #21 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!
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!
U usama_hawas Registered User. Local time Today, 13:25 Joined Aug 20, 2019 Messages 10 Aug 20, 2019 #22 it is very helpful
P Pat Hartman Super Moderator Staff member Local time Today, 16:25 Joined Feb 19, 2002 Messages 47,202 Aug 21, 2019 #23 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 Click to expand... This was a typo. You CANNOT cancel the AfterUpdate event. Validation belongs in the BeforeUpdate events which you can cancel
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 Click to expand... This was a typo. You CANNOT cancel the AfterUpdate event. Validation belongs in the BeforeUpdate events which you can cancel
