Protect from delete

[rob p]

We have appr 1000 numbered (1 - 1000) boxes. I made a table with box number
the first field (auto numbered). I use this field in a relationship with a
contents table. (More than one contents to a single box).

I need to control the deletion access somehow. (for my users, I'm scared
they may delete pressing the red X on the toolbar.) In testing, it seems
once I delete a number I cannot restore it.

Say I have deleted box number 5 from my 1000 boxes. Autonumber will allow
me to create a 1001 box. I find out I shouldn't have deleted box 5 and want
to bring it back. Is this possible? Or should I set the table field up
differently.
Thanks.

 

[Douglas J. Steele]

You need to set the table field up differently: Autonumbers will be lost
upon deletion.

I'm not sure I understand, though, why you'd be deleting the box number from
the table. Simply set the form's Allow Deletions property to False.