Locked Field

[Guest]

Hi all,
Some of the fields on my form are unlocked only when pressing the add
button on the form. However, I found that those fields remain unlocked with
pressing the previous/next on the record status bar after pressing the add
button on the form. Are there any ways to lock those fields whenever users
press the previous/next button on the record status bar? Thank you for your
kindness.

 

[Guest]

Hi KFC,

You can use the Form_Current() event procedure to lock down either the
entire form (Me.AllowEdits = False) or you can lock down just individual
controls (Me.ControlName.Locked = True).


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi all,
Some of the fields on my form are unlocked only when pressing the add
button on the form. However, I found that those fields remain unlocked with
pressing the previous/next on the record status bar after pressing the add
button on the form. Are there any ways to lock those fields whenever users
press the previous/next button on the record status bar? Thank you for your
kindness.