Help with this form I attached data

[hmho]

I attached the data file. I have form for data entry to table and it is continuous form and every day we enter about 60 items, what I like to do is enter all the data and then have the option to save yes or no "Do you want to save yes or no". Right now when I enter information to each field it automatically gets saved to the table. How do i do this.

Thanks

 

[Galaxiom]

Use unbound controls to enter the data.
Append the data to the table on some event such as clicking a Save button.

 

[hmho]

Use unbound controls to enter the data.
Append the data to the table on some event such as clicking a Save button.

I got the first part for unbound controls but how would I append to save in the table? Thanks

 

[Galaxiom]

One way is to run an sql command with an append query

DoCmd.RunSQL "INSERT INTO tablename (field1, field2, etc) SELECT Forms!FormName.ControlName1, Forms!FormName.ControlName2, etc;"

Disable the save button after the sql runs or you might run it twice.
Then you have to clear the boxes for the next record and reenable the button.

There are probably nicer ways where you can talk to the RecordSet.