Set up a form so users dont delete table records

Set up a form so users dont delete table records

Post by R2Vvcmd » Sat, 24 Jun 2006 10:08:01


Hi,
I would like to edit my form so it will only allow users to enter and save
records but not scroll through them and accidently delete them. Is this
possible?
I.e can i delete the scroll on the bottom of the form with all the table
details in it?
Cheers
George
 
 
 

Set up a form so users dont delete table records

Post by Rob Parke » Sat, 24 Jun 2006 10:37:11

Hi George,

You can remove the navigation buttons at the bottom of the form by setting
the form's Navigation Buttons property (it's in the Format tab) to No.

You can set the form to only allow new data to be entered by setting the
Data Entry property (it's in the Data tab) to Yes. If you do this, and
leave the navigation buttons visible, they will not function anyway!

You can prevent record deletion by setting the Allow Deletions property (in
the Data tab) to No. You can prevent editing existing records by setting
the Allow Edits property to No.

For all these properties, you must have the form itself selected (click on
the small black square at top-left in design mode).

Check it out. Find which approach is best for your specific application
design.

HTH,

Rob

 
 
 

Set up a form so users dont delete table records

Post by R2Vvcmd » Sat, 24 Jun 2006 11:03:02

Thats a great help Rob,
Have a good day. Go Australia!
 
 
 

Set up a form so users dont delete table records

Post by Rob Parke » Sat, 24 Jun 2006 11:57:20

You're welcome. And yes, Go Australia!!!