J
Jimbo213
We want to lock a record when the status field on that record = 100.
If MasterTable.Status is 100 we'd like to lock that row from any updates
[both updates from the form that displays the table fields and from the table
in datasheet mode.
Is that possible and how to do it?
Here are my thoughts:
1) conditional format each of the 140 fields on the multi-tab form to be
disabled if Score=100 on that record
2) somehow [?] put disable code into each field's OnGotFocus event property
3) lock the specific record from any COMMIT somehow when the form is open to
that record
What-say the experts?
Thanks for your reply & assistance.
Jimbo213
If MasterTable.Status is 100 we'd like to lock that row from any updates
[both updates from the form that displays the table fields and from the table
in datasheet mode.
Is that possible and how to do it?
Here are my thoughts:
1) conditional format each of the 140 fields on the multi-tab form to be
disabled if Score=100 on that record
2) somehow [?] put disable code into each field's OnGotFocus event property
3) lock the specific record from any COMMIT somehow when the form is open to
that record
What-say the experts?
Thanks for your reply & assistance.
Jimbo213