By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,473 Members | 3,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,473 IT Pros & Developers. It's quick & easy.

Disabling the saving of records when adding a record

LeighW
P: 73
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
Jul 2 '12 #1
Share this Question
Share on Google+
2 Replies


100+
P: 759
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.
Jul 3 '12 #2

LeighW
P: 73
This is a good idea. Thanks Mihail.
Jul 4 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.