When I pass on a table that progresses through a line of people for approval, I have made the previously entered info is read only. This is great, except that I have a couple of fields that remain empty within the table that needs to be accessible if they are empty.
This chart has gone through the first person. They selected the status of the items they are approving/rejecting. The first four fields are prepopulated from another form, but require the Status field to be completed on this, and future versions. The last field is populated base on their current user.
The table is then passed on to the next user. I wish to make the empty Status filed editable. I would like all Status fields that are empty to allow editing. I have tried various ways to do this, but to no avail. I think that the empty fields are considered as "previous data". Is there a work around that can help me stipulate that empty status fields are not read only? Or, that filled Status fields are read-only?