Execute Notes field default value formula without opening the form
Execute Notes field default value formula without opening the form
I have a form with total fields that derive their value from a @Sum(DBLookup) default value formula. The totals update whenever the form is opened. However, I want to update the totals WITHOUT opening the form. I tried the following code in an agent with no success. Can this be done? Set viewC = db.GetView"(StudentProfs)") Set docC = viewC.GetFirstDocument Do While Not docC Is Nothing Call docC.ComputeWithForm(True, False) Call docC.Save(True, False)