Record level access issue?

[Jimjmn]

I have created a DB with a button on it that changes the state of a field (lock) from 1 to 0 (1 being default). In Custom Record Privileges I set up the edit column to be "limited" so that whenever the field (lock) is not 0 the record is editable. All of this works but where the issue lies is that when I click the button and it changes the field (lock) from 1 to 0 and so forth the access to the record is not immediately changed until I click somewhere else on the layout. Is there a setting that will correct this behavior?

[efen]

Add a commit records step to the end of the script on the button

[Jimjmn]

Efen...thanks so very much!!!

One more question:

Is there a way to add a custom dialog when the end user tries to input on a field that access has not been granted?

[efen]

I don't think so - the user is warned by a standard message that the record cannot be amended

[Steven H. Blackwell]

Put a triggered script based on OnKeystroke to trigger the message.

Steven