Hi All
I'm trying to figure out how to do validation in a form. I have a date field that the user enters. In the validate routine I take the date and find the appropriate defined period based on the entered dates and the start end dates of the period. If I find the appropriate period I update another field and all is ok. If I do NOT find a valid period, I change the comment to 'Date not in valid period. I also set loc:Invalid. The error comment display works but even though I set loc:Invalid the form still accepts the invalid date.
If I copy the validate code to validate record then the form will not take the date BUT the comment is not updated. I also expected the field to be colored?
So, what is best practise for doing field validations where the validations are more complex than simple range, alpha etc.
Cheers
Chris