Protect Subform Data 1

[SMHSleepy]

I have a subform linked to my main form by a one-to-many relationship (one main, many subs). When I pull up a record on my main form, the subform shows the first match as well as the total number of matches on the bottom. It's easy enough for the end user to add a new record on the subform by clicking the "Add Record" button I created, but how do I prevent someone from just over-writing the existing record that's showing? I ran into this potential problem during a test run. Thank you in advance.

 

[MajP]

You could set the property of the subform to
allow additions: true
allow edits: false

Personally I always divide data entry, data editing, and data viewing. Normally I have forms to view and search and buttons to add new record or to edit record.

 

[SMHSleepy]

Thank you MajP, I actually took your last point more to heart and created separate forms for data entry. Then I set the Data Entry property to True so that all the user can do is enter new data. Thanks again for the tip.