I need a help.
(db Attached)
Thanks for some friends especially “thedbguy” who shared codes to lock a form by a combobox. I disabled/ Locked a form by a combobox, it works but I want to check some fields, which should be populated before form lock as following;
After selecting CLOSED from STATUS COMBO BOX of PREVENTIVE MAINT CLOSED FORM , should be
(db Attached)
Thanks for some friends especially “thedbguy” who shared codes to lock a form by a combobox. I disabled/ Locked a form by a combobox, it works but I want to check some fields, which should be populated before form lock as following;
After selecting CLOSED from STATUS COMBO BOX of PREVENTIVE MAINT CLOSED FORM , should be
- DATE COMPLETED should not be empty (but future date not allowed)
- REMARKS Combobox should be populated as “ COMPLETED”
- Supervisor Combobox should not be empty