Stop allowing creation of records based on record criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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