MS Access when i close the form empty record is insertig into table

[veeru8989]

Hi,
i created form in ms access using form wizard.
and entered data in the fields and click on save button the record is inserted into table.its Logic is working fine and when i click on close Form button in form it is inserting empty record in table.

can anyone please provide the solution how to prevent empty
record when i click on close form button.

[twinnyfo]

veeru8989,

Could you please post the code behind your form? This will help us look for solutions.

[zmbd]

also version of office/access

[NeoPa]

Check the record selectors. If your new record has been dirtied (Some change has been made to the data in there.) then anything you do that takes the focus away from that record will save it. As the Close button is off the record this will necessarily happen before it executes the code behind the button.

As I say, check the record selector. It will show a pencil icon as soon as the current record is dirty. It's a very important thing to look out for when using Access.