Allow new record entry but restrict editing of existing records in form controls

[Tom via AccessMonster.com]

Hi , I have a form where I would like users to be able to enter new records
(with the new record button maybe), but I dont want them to be able to edit
any existing records with this form. Is there a way to do this? Should I have
a command button that opens a new entry form, and lock all the records on the
main form so editing is not possible? It seems like I would have alot of
small "Enter New Record" forms. I dont want users to be able to delete old
records.

Thanks

Tom

 

[Rick B]

I think setting the form's "data entry" property will accomplish what you
want.

 

[John Vinson]

Hi , I have a form where I would like users to be able to enter new records
(with the new record button maybe), but I dont want them to be able to edit
any existing records with this form. Is there a way to do this? Should I have
a command button that opens a new entry form, and lock all the records on the
main form so editing is not possible? It seems like I would have alot of
small "Enter New Record" forms. I dont want users to be able to delete old
records.

Set the Form's Allow Additions property to True, and its Allow
Deletions and Allow Edits properties to False.

John W. Vinson[MVP]

 

[Tom via AccessMonster.com]

Thank you both

Tom