Trouble with subform datasheet

[Guest]

I have a subform that displays the datasheet from a table. I have this form
set to allow new records and edit existing ones, however, when I close this
form, Access adds a blank record. If I am in and out of this form 4 times a
day, Access would have added 4 blank records to my datasheet. How do I
prevent this from happening?

 

[Allen Browne]

Access does not add blank records on its own. There must be something that
is assigning a value to a bound control. For example, you may have some code
in the form's Current event that is dirtying the form.

It would be good to track that down, but another approach is to open your
table in design view, and set the Required field to Yes for one of the
fields. This will prevent it saving the record unless that field at least
has a value.