Access 2010: Forms Commit Data Changes When Record Is Changed - Yikes!
Posted on 2012-03-31
Hello - New to Access 2010, I am noticing Access 2010 seems to commit data changes in text boxes, on a bound form ONLY when a different record is displayed on the form - NOT when the focus moves to a different text box (After Update) on the form as in Access 2003! - This behavior is problematic.
I understand it is possible to add the VBA command:
to the On Change event for all text boxes, but this seems very inefficient - particularly if there are lots of text boxes on the form (and many forms!).
So, how is it possible to have data changes in text boxes committed to the underlying table After Update for ANY text box on a form, without having to add a Do Command to each text box On Change event?
Many Thanks - Jacob