Cancel an update

S

SHIPP

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

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.
 
Top