Dear All,
I have statuscode field which has statuses 10,20,30,40 and 50. StatusCode 50 indicates the activity is completed. There is also another field DateCompleted. I desire that when users update the statuscode to 50 (completed), they must first enter the dateCompleted field. In other words, when the dateCompleted field is blank and users updates the statuscode to 50 (complete), the user should get a validation text or messagebox that "You must first update the DateCompleted" and new status should be cancelled and focus should shift to DateCompleted field. For other statuscodes, it should not give any message.
I tried using beforeUpdate event of Statuscode to achieve this but was not successful. Require some assistance.
Kind Regards,
Kumar
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar