Delete If NoData in Subform

[Haytham]

Hi All...
I have a form filling a data and then it saves before moves to subform ( Both joined by Bill No).
The subform is tabular. It should contain data, otherwise when close the main form it should check: If NoData in subform .. MsgBox (No Data in subform) and focus back to first field in subform, if not enter any data in subform, record should be deleted when close...
How can I do that....

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49897

 

[Haytham]

Exactly what I need.
Thank you