Hey All,
So this should be a fairly simple problem. I've got a relatively code heavy form in which I track internship durations and payments. I currently have a Start Date and End Date from which the number of working days is calculated. Due to some irregularities in the way these internships can be scheduled I also have an Internship Correction box. The control source for my Number of Workdays is as follows: =(CalcWorkdays([First Day],[Last Day]))-[InternCorrect]. The CalcWorkdays is the function I use to count only weekdays and exclude weekends in my calculation.
Now here's my problem. Updating either date field or correction field is supposed to re-query the calculated field. However, when I update a field the Number of Workdays field tends to go blank and only after clicking on several controls does it appear. The calculation is always correct but this disappearing value is rather disconcerting. There are a number of other fields that rely on this Number of Workdays for their calculation and they do not appear to update until the new value appears again. Does anyone have any idea why this may be occurring?
Thanks.