Securing records in a form

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

I have a form named frmqul. It contains eleven fields, directly from a
linked table in the front end of a Access Database name Subscribers.
One of the fields, [Comments] requires constant editing.
I would like to make this field editable, but prevent record deletion by the
individuals editing the field.
This needs to be done in Access 2003, but we will soon be updating to Office
2007.
Any suggestions will be appreciated.
Thanks
Paul
 
In the properties for your form you can turn off 'Allow Deletions' make
sure your comment field is not locked

See if that gives you the control you want
 
That does the trick.
Many thanks

Chegu Tom said:
In the properties for your form you can turn off 'Allow Deletions' make
sure your comment field is not locked

See if that gives you the control you want

PA said:
I have a form named frmqul. It contains eleven fields, directly from a
linked table in the front end of a Access Database name Subscribers.
One of the fields, [Comments] requires constant editing.
I would like to make this field editable, but prevent record deletion by
the
individuals editing the field.
This needs to be done in Access 2003, but we will soon be updating to
Office
2007.
Any suggestions will be appreciated.
Thanks
Paul
Click to expand...
Click to expand...
 
Back
Top