SITUATION: Access 2010, Form, two unbound text boxes.
-- Box1 default is Date()
-- Box2 default is a date three to five days later, generated by a custom function. (Considers holidays, weekends, etc.) Function is fine -- tested thoroughly in the Immediate window, produces the correct result.
-- But when Box1 is changed, either via the DatePicker button or by the user typing in a different date, Box2 doesn't update. Have played around with every imaginable (to me) combination of Refresh/Recalc/Requery/Repaint and the Enter, Exit, BeforeUpdate, AfterUpdate, OnChange, GotFocus, LostFocus, etc., etc., events on both boxes.
I think I could write some long, arcane VBA procedure to get where I need to go, but surely there must be a built-in solution to something this fundamental. Anyone?