Forum Discussion
Create a macro on a date field
Hi. I need to create a message box indicating that the age of a patient is less than 18 when that is the case. This would appear after entering the patients date of birth. I set up a macro on lost foc...
i think the control will Retain the Value even if the record is not yet saved.
you can test it on the BeforeUpdate event of the control.
you can test it on the BeforeUpdate event of the control.
"...the control will Retain the Value ..."
Yes, that's the case. Hence the line: Me.DateofVisit.Undo in the suggested response.
And, you may also have missed that I DID suggest the BeforeUpdate event.
Yes, that's the case. Hence the line: Me.DateofVisit.Undo in the suggested response.
And, you may also have missed that I DID suggest the BeforeUpdate event.