Hello
I have (parent) form that has default view = Datasheet
I have a subform that has default view = single form. On that subform, I have a calculated field (name = AverageScore) in the formfooter of that form.
Then I placed another field with controlsource =QuestionList.Form!AverageScore on the main form (= the calculated field of the subform QuestionList included on the main form).
When we open the form, we do see the Average column with #Error come up.
Once we click on the plus sign to open the subform, the the values in the column above are refreshed (requery somehow triggered). Also, when both parent and subform are in single form view, then it also works.
How to force a requery of the main form (datasheet view) so that column AverageScore column has values in every record shown ?
Thanks,
Yves
I have (parent) form that has default view = Datasheet
I have a subform that has default view = single form. On that subform, I have a calculated field (name = AverageScore) in the formfooter of that form.
Then I placed another field with controlsource =QuestionList.Form!AverageScore on the main form (= the calculated field of the subform QuestionList included on the main form).
When we open the form, we do see the Average column with #Error come up.
Once we click on the plus sign to open the subform, the the values in the column above are refreshed (requery somehow triggered). Also, when both parent and subform are in single form view, then it also works.
How to force a requery of the main form (datasheet view) so that column AverageScore column has values in every record shown ?
Thanks,
Yves
Attachments
Last edited: