PDA

View Full Version : SOLVED: Disable deleting data from table



banavas
07-16-2004, 12:39 AM
Dear Friends,

I have a table called customers and created a form to enter data in the table.
However, I want to give the user no option of deleting or overwriting existing table records. In other words I want the form always to go after the last record of the table and add new records with changing anything else in the table.

Any ideas how to do that?

Thanks,
G

SJ McAbney
07-16-2004, 01:23 AM
First of all, you shouldn't bind a table to a form...ever.

Always use a query - even if it is effectively another object that displays all the table's records. With a query you can sort the records loaded into a form.

All you need to do to resolve your problem is find the form's DataEntry property and set this to Yes.