Unanswered: Only save to table on an event on a bound form
Hi, is it possible to have a bound form with text boxes bound to fields in a table, which when these text boxes are changed they will only be saved in the table when clicking a button (or on any chosen event)? Otherwise they don't write to the table if certain conditions are not met (e.g saying no to "Do you want to save changes)? Or is using unbound forms with ADO or DAO the only way of doing this? I already know the ADO method, just wondering if I can save myself from fully recoding a form.
Many thanks for your help. The main issue I have is when you make a change to the data in the text boxes (which are bound to the table), how can you stop it from writing data to the table, or undo if the user says no to saving changes when closing the form (from which your example will aid me to detect if there are changes)?