Printable View
I must develop a MS Access database that will NOT automatically save any entered data in form fields until someone actually presses a Save button on the form.
MS Access automatically saves data entered as a default. How do I get around this for multiple forms and fields?
Create a form with the bound fields Visible property set to False. You can use the OnCurrent Event to populate your unbound fields, make changes or additions in the unbound fields. Create a command button to transfer the data in the unbound fields to the bound fields.
Or........
just have unbound fields on your form so when the Save button is clicked you open a recordset or sets on the appropriate table(s) and Add the data to them that way.
This requires more coding effort than the other idea but gives you absolute control over what is going on and how it is handled.