G Guest Feb 13, 2004 #1 I have a form with a field that at times contains a zero. When this field contains a zero I would like to cancel the update using VBA code. I am running Access 97. Any help would be appreciated.
I have a form with a field that at times contains a zero. When this field contains a zero I would like to cancel the update using VBA code. I am running Access 97. Any help would be appreciated.
A Andrew Smith Feb 13, 2004 #2 In the BeforeUpdate event code put: Cancel = [NameOfField] = 0 SHIPP said: I have a form with a field that at times contains a zero. When this field Click to expand... contains a zero I would like to cancel the update using VBA code. I am running Access 97. Any help would be appreciated.
In the BeforeUpdate event code put: Cancel = [NameOfField] = 0 SHIPP said: I have a form with a field that at times contains a zero. When this field Click to expand... contains a zero I would like to cancel the update using VBA code. I am running Access 97. Any help would be appreciated.
