Hello ,
I want to lock some records individually can i do that If yes please tell me how??
Thanks
Hello ,
I want to lock some records individually can i do that If yes please tell me how??
Thanks
You need to add an extra field to the record and set it to boolean type. give it a meaningful name and set the default value to True
Now each time you visit the record in single form view you can toggle the allow edits option to according to the record status.
can you tell me the code by which i can lock individual records..............
Go to the form properties and you will see an option Allow Edits set this to No.
An alternative is to use VBA to set the controls that can't be edited
Me.FieldA.Enabled = False
Me.FieldA.Locked = True
and vice verca to swith the edit mode back on.
This option is the better option as it will allow you be selective on what fields can or cannot be edited.
ExlGuru
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks