Using a form with a 'one' record Control file Table

  • Thread starter Thread starter Isis
  • Start date Start date
I

Isis

I want to use a single record 'Control' file Table - if I create a form to
update the table how do I ensure that only 'edits' - no adding or deleting
the record can happen - IE the Control file Table will only ever have a
single record in it (with multiple fields).

Thanks
 
Douglas J. Steele said:
Set the form's AllowAdditions and AllowDeletions properties to False.
Click to expand...

I also like to give the table a primary key with a validation rule that
the key field must have the value 0. That way, there's no way a second
record could ever be added.
 
I also like to give the table a primary key with a validation rule that
the key field must have the value 0. That way, there's no way a second
record could ever be added.
Click to expand...

Thanks to both of you.

Regards
 
Back
Top