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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Mail Merge skipping records/sending one at a time 0
Merging from an Excel file with graphics 1
Copy previous record into form field 0
Improving Macro That Keeps First Letter 0
Automation of scanned file storage based on content 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How to remove a bracket that is itallicised for an entire document 1

Top