I have a form with several controlled access sections. Each section resides in a different subform, and the subforms are placed directly on the form (not computed).
The access list for each section contains a mix of usernames and database roles.
I have been tasked to add a new section that is only editable by the document originator and a new database role [New Role].
Ok work is done, so I’ve been testing. I have a test user ID that has author access to the database and has been given only the new database role [New Role].
Well the test user can edit the new controlled-access section just fine. However, they can also edit some fields or PARTS of fields from the other controlled access sections on the form (none of which they should have access to according to the ‘Who may edit the contents of this section’ popup).
For instance, one of the other sections is editable only by the [System Admin] role (at least that’s what it says when I double click on the section). It contains several fields, but when I access documents as the test user, I can edit the field at the BOTTOM of the section? The other fields are read-only?
I have never used controlled access sections before and I’ve inherited this code from someone else. Are they even reliable?
I’ve even noticed for a couple of these sections where the last field is a text field, if there are two lines of text in the field and I collapse the section, the first line of text in the field is hidden and the second line of text is still shown below the collapsed section?