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

  • Thread starter Thread starter Tom via AccessMonster.com
  • Start date Start date
T

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
 
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.
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top