Subforms And Required Fields

Hi,

I have a main form with one subform (Datasheet view). On the main form, I have an On-Click Event button (“Save and Close”) which sets required fields on both the main form and the subform before saving the record.

Here is the problem:

- I start by entering some data in the main form
- I then tab into the subform and enter data
- I then tab out of the subform back into the main form – this is where the problem begins: When I enter all available data in the subform, including satisfying the required fields, and tab out of the subform back into the main form, the subform seems to initiate an extra new record – so… upon clicking the “Save and Close” event button on the main form, the event looks for the required fields of the blank subform record to be populated (a record that I do not have any data for). I also noticed that this required field notification in the subform can be satisifed by simply populating more fields in a previous subform record???)

I have tried a few things to resolve this and have looked throughout this forum without any luck – hope I didn’t miss something.

Any help would be appreciated. I have attached a very simplified version of my database.