Lock Selected Records in a Continuous Form
This shows how selected records can be locked in continuous forms whilst allowing all other records to be edited normally.
The demo app and all code is available from https://isladogs.co.uk/lock-records-c...
See also the related article https://isladogs.co.uk/paint-me-trans...
TIMES:
0:00 Intro
0:32 Example app based on students in a fictitious school
1:24 Tick Lock checkbox to lock a selected record and precvent further editing
1:51 Basic code (Form 1) - lock textboxes & combo boxes when Lock checkbox ticked
3:01 Modifications to code in Form 1
3:40 Form 2 - include checkboxes in code - Lock checkbox also becomes locked when ticked
4:30 As above, but Lock checkbox can be unticked in case of errors
4:55 Code for forms 2 & 3
5:12 Form 4 - shows a lock image only when checkbox ticked - use transparency property of command button overlaying image
6:32 Summary & links to articles / example apps
8:33 Thanks for watching. Please like, leave a comment & subscribe.