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)
Set docC = viewC.GetNextDocument(docC)
Thanks for any suggestions!!
Tags for this Thread