Stop allowing creation of records based on record criteria

J

John

Is there any way to not allow the creation of a new record if any previous
record has a certain value in a field?

Thanks in advance,
John
 
D

Douglas J. Steele

In the form's BeforeUpdate event, check whether or not that value exists. If
it does, display an error message to the user, and set Cancel = True
 
Top