I was asked to redesign some of the forms in a database and I wasn't sure if a section is the way to go. The situation is this- initially the form was to be created only by editors of the database. Now there are 4 fields on the form that need to be able to be edited by users with author access who are not the creator of the document Of course the editor users will still be able to edit every field. I was trying to use a controlled access section and place two roles in the access formual box -"[Admin]";"[Auditor]". The admin role is applied to users with editor access and auditor to users with author access. I can't get it to work. Or maybe I don't understand how it will should work. If I select computed as the type on the access section of the Controlled Access Section wouldn't that mean that user who had the Admin or the Auditor role could edit the section? Or because the section is on a document that author users can not edit - they can't edit the section either.
Is there another direction I should be going in - maybe using a subform or something? I just don't want to lose any of the information I have in the database - If I do use sections - are you allowed to place your text and fields to be placed in a section in a table first? I didn't see where it says you can't be I can't seem to do it.
I realize this is a lengthy note - I am very green at developing notes and just thought I would ask for any advice.