I have a form where users enter details about a job that needs to be done. In some cases there is a charge (ChargeAmount field) and if they enter a charge amount they need to enter ChargeDetails field too. It's not happening so I tried setting the On LostFocus event to check
IF IsNull(ChargeDetails) and Not IsNull(ChargeAmount) THEN
MsgBox "You must enter a text",,"Text Required"
The message appears but the focus does not return to the field. Is there any other way of forcing this?