Make sure there is always at least one record.

J

James

How do you keep a record from being deleted. Just the one record not all of
them, but allow any other record to be deleted?
 
J

JohnFol

You cannot.

What you can do is make sure any forms that reference the table have some
code on teh Before Update that checks to see if delete is allowed, and if
not set Cancel = True
 
Top