I have a form that is going to be completed in two parts, by two different people. Is there a way to lock in what the first person fills in, so that the second person can't modify, but still keep the rest of the form accessible for the second person to complete?
Yes ....I would wrap the two different parts that each user has to fill out in a subform and then create a scripting function to lock all fields in a given subform. I have included a sample that will show you the scripting object to do the locking. In this case it is locking the entire form, but if you pass in the subform that you want to lock then it will only lock the fields below the subform. The code to call the scripting obejct is behind the lclick event of the lock fields button. In my case I am passing in form1 (which is the root node of the form).