Just to follow up I created a form to act like a message box displaying the error message.
I then added an uncontrolled textbox on the mainform to mirror the control in the subform and it recognises when no entry is made against this new textbox.
I then added an uncontrolled textbox on the mainform to mirror the control in the subform and it recognises when no entry is made against this new textbox.