I may not need the update event after all. Am I correct that Me.Dirty-False updates the Forms Record source to the now values in the controls ? This appears to be so but good to be sure.
I'm not entirely certain I understand that question.
Me.Dirty = False will force the form to SAVE ... Meaning any bound controls' current values, will become the values stored in the Table to which the form is bound, at that moment. Yes.
If you mean will this command actually change the form's Recordsource - like the form used to be based to tblOne and now it's based on tblTwo - No, it has nothing to do with that.
In which case this comment before the Record source changes will do it
I'm not quite sure what you mean by that. Put simply, if you want the changes actually saved to disk - completely saved into the underlying Table - as soon as anyone finishes entering any particular value in a control (say, they finish typing a word in a textbox), you'll have to add that command to code which you place in that control's (Textbox's)
AfterUpdate event. The event will fire generally once they leave that control (tab, exit, click somewhere else, etc).
If you just meant that you want the data to save to the Table at the point in time where someone navigates to another record on the Form, well, it does that anyway.