I have a TEO on a form, assigned to the Field “ReviewHoldDate” (field properties are Date MM/DD/YY) with the procedure below attached. The procedure is triggered at End Editing. If I click in the TEO, enter a date and exit the TEO – the procedure removes the date (because the DBO/field ArchiveNo = X) and displays the message. BUT, the cursor continues to blink in the ReviewHoldDate TEO as if it is still active. If I click in any other TEO on the form – I get a blinking cursor in both. I have tried multiple different ways to resolve this without success, including creating a new database with just these two fields/objects. Also, I have other procedures assigned to different TEO’s… without problems – only this one.
If ArchiveNo = “X"
Beep Message “You cannot enter an Archive Hold Date if the record series does not have Archival Status!” Stop
Note: ClearCell also works.