>Thanks for the advice. I've got the PreSaveHook working but I'm still having problems with the VALID.
>
>I put the following code in the VALID method and thought it would prevent
>the focus from changing to the next field/control until data was added to
>the "UnitNo" textbox. However, the textbox still looses focus. Any
>suggestions on how to keep the focus locked on the textbox until data is
>input.
>
>I also replaced the RETURN with a .setfocus command but got an error that
>this was not allowed in a VALID method.
>
>
>IF EMPTY(ALLTRIM(thisform.txtEmergency_UnitNo.Value))
> WAIT WINDOW "Unit Number is Required for ALL Emergency Orders!" TIMEOUT 2
> RETURN
>ENDIF
>
>
Instead of RETURN, use RETURN 0 <g>
Also you may need to add some logic to be able to get out of the field if you press on Cancel button or try to close the form. Otherwise you would be stack in the field. I have code at work to do so.
If it's not broken, fix it until it is.
My Blog