Suppress Blank Records on Form Close

[Guest]

I have a form for data entry on employee training, with an associated subform
for viewing existing training records.
Whenever data is put into an employees record, if the form is closed the
data is in the table, but there is also a blank record as well. As a work
around I created an employee 'ABlank Record' so the sort has this employee
first, so when the data entry is finished Mr. Record is selected and collects
all the blank records. Is there something wrong in the setup doing this? I
have tried all the combinations I can that keep the data entry and record
viewing functionality, but I would like to turn over the form to someone else
without them having to do the workaround. Thanks.

 

[Allen Browne]

The Close event of the form is too late to block this. The record is already
in the table.

A simple workaround is to open your table in design view, and set the
Required property of one of the fields (e.g. Surname) to Yes. It will then
be impossible to save a record with no surname.