Securing records in a form

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
 
C

Chegu Tom

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
 
P

PA

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...
 

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

Can a Check Box Prevent Other Fields from Being Used? 1
Sorting Records in a form 11
Auto number records when a form opens 5
Combo Box Form Query - Erases Existing Fields When Formatted 3
allow certain users access to fields in a form 2
Displaying a Word doc in form 3
Can see Fields in Design View but not in Form or Layout view 3
Tailor a form to enter vriable records 5

Top