Making bound forms is all good. It alloys folks with no experience to build a functional database.
But it exhibits some pretty terrible attributes.
Namely controlling unsaved data.
What are some of the way you guys deal with this serious problem.
I now rarely use bound main forms. Obviously all of my subforms are bound, but I find more and more reason to keep my forms unbound. Now, it takes a little more code and error checking. I use DAO rs.AddNew; that way I never worry about dirty records.
Not so much for editing existing data but for adding new records.
Any thoughts?
But it exhibits some pretty terrible attributes.
Namely controlling unsaved data.
What are some of the way you guys deal with this serious problem.
I now rarely use bound main forms. Obviously all of my subforms are bound, but I find more and more reason to keep my forms unbound. Now, it takes a little more code and error checking. I use DAO rs.AddNew; that way I never worry about dirty records.
Not so much for editing existing data but for adding new records.
Any thoughts?
Last edited: