Disabling the saving of records when adding a record

[LeighW]

Hi all,

I am adding data to comboboxes within a subform. I'd like to be able to add more than one record without it saving and then have a dedicated save button to save the data. The problem at the moment is, you add a record to the subform and when you click the next combobox to add another record it updates and saves the last one.

The reason I want it not to save is for quality assurance reasons with the save button activating a footer which requires info on why you are editing/adding (which I have occuring on other forms). Because of the data involved I'd prefer not to have the user enter a reason for adding a record every time they add one, and instead quality assurance and updating will occur after adding all the records they want.

Is there an easy way of doing this?

Thanks for any help,

Leigh

[Mihail]

Use a temporary table to store the new records.
Then, when hit the "Add" button, add this records to the main table and clear the temporary table in order to add a new set.

[LeighW]

This is a good idea. Thanks Mihail.