Sorry for the delay in responding. And yes, it is essentially the sort of code that William suggested. It sounds as though you are dealing with a continuous form that is a subform on a main form. There is a BeforeUpdate form event that is triggered each time a record is changed (there is also a BeforeInsert event), and you can put code on it to check each field that requires data being entered. In addition, you can put a constraint on a text box that says an entry must be made, so if a user tabs through a text box leaving it null, the form will stop and require an entry before moving to the next text box. That doesn't require any code, although you can also put code behind each text box to do checking. Hope this helps.
You can't see the view if you don't climb the mountain!