I want to set up a form so that users:
- Can view/sort/filter all existing table records
- Can add new records
- Cannot edit or delete records once they have been added
I tried the following property settings:
- Allow Additions="Yes"
- Allow Deletions="No"
- Allow Edits="No"
With these settings, edits and deletions are disabled, but it's not possible to add new records; there's no asterisk row at the bottom of the table for adding new records, and the navigation controls at the bottom of the screen have the "Add new row" icon grayed out.
When I set Allow Edits back to "Yes", I get the new row re-enabled, but I also get the ability to edit existing rows, which I don't want. How can I allow adds but prevent edits?
EDIT: I originally built this form by creating a blank form, then dragging the table onto the form. When I built it differently, by opening the table and then clicking the Create Form button, I was able to set it to allow additions, but not deletions or edits, using the above property settings. Seems like this is an issue with the way the form is set up when created using drag-and-drop.
