>Can anyone tell me why the ProgrammaticChange event does not fire when a textbox has a ControlSource and the value of the source changes? Doesn't ControlSource alter the Value property of the textbox when the data source value changes? Is there a workaround for this?
It seems to me that ProgrammaticChange() is supposed to fire only when you alter the .Value in a command in your program.
If the user changes a value, the event to check is InteractiveChange().
If you go to another record, for example, you should include the corresponding "Event" into your framework; so that, for example, the button "go to next record", as well as other similar commands, would include a call to a method which you might call OnRecordMove().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)