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

[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]

Set the form's AllowAdditions and AllowDeletions properties to False.

 

[Dirk Goldgar]

Set the form's AllowAdditions and AllowDeletions properties to False.

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.

 

[Isis]

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.

Thanks to both of you.

Regards