Dataview based form + single form subform

Y

Yves

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Populate main form from subform record 0
Unremovable horizontal scroll bar on subform 1
Trouble Filtering a Sub Form With Combo Box Options 2
First Subform record gets modified when closing form 3
Subform of subform not being linked 3
Split Form in Subform or same effect 2 subforms 0
Trouble associating parent form record to subform's record 1

Top