Record inserted into table when closing form 1

[ba543]

The problem is, whenever I close the form, another record gets inserted, with
mostly null values in its fields. This also happens when I go from form view
to design view. The "On Close" event for the form doesn't tell it to add
another record, so why is it doing it? Is there any way I can make it stop,
so I don't have all these extra records every time the form gets closed?

Any help would be greatly appreciated, thanks.

 

[BobJacksonNCI]

Guessing here...

I suspect you have some default values that are landing in your table. You can prevent that by using a command button to close the form. Within the code, include a Me.Undo.



HTH,
Bob

 

[AJN2004]

Another cause could be how you allow you form to deal with data. If for example your form is set to enter data as a property in the properties dialog, then on opening the form a new record in the underlying table is created. Even if you don't enter data on the form, the new record is there with the values that are set as standard in the design view for the table.

hth