Form for new record

[GeorgeMAR]

I want create a form to add new employees, but I don't
want the record to be created until the user hits an ADD
button.

At present, as soon as the user enters data into even one
field, the record is created.

For the ADD button, I am using Docmd.GoToRecord
acDataForm, "formname", acNewRec.

I also have a CANCEL button, which has been set to cancel
in properties and does Docmd.Close. That does not work,
the record is still created.

How can I prevent the record from being created until the
ADD button is clicked?

many thanks
george

 

[Duane Hookom]

Create an unbound form. Then use code to insert the values into a new record
following a button push by the user.