I have a text box which I validate as "must be equal to Y or N" in a Before update procedure.
I the check fails I use a cancel = true.
This works fine if the user presses the enter or tab keys
The user may however press a function key (form keydown).
When this happens the validation process kicks in and the msgbox error message is displayed (vbcritical).
However, when the user clicks OK, an error message is displayed -
run time error 2467
The expression you entered refers to an object that is closed or doesn't exist.
Any ideas how to trap this error or work around it