Arthur Fuller
fuller.artful at gmail.com
Wed Oct 28 11:20:03 CDT 2009
With all respect to David, I would create a function and call it from OnCurrent rather than embed the logic therein. Different strokes for different folks, I guess. My approach is always to isolate functionality, not least because I might need to call the same code from somewhere else in the app. A. On Tue, Oct 27, 2009 at 1:23 PM, David McAfee <davidmcafee at gmail.com> wrote: > I'd keep it in the OnCurrent event. > > Use NZ() and some future date > > 'DateEarlyExp.value = DateDiff('d',Date(),NZ([DateEarlyExp],DATE()+365)) > >