子窗体总计值到窗体中的文本框返回错误 [英] Subform totals value to textbox in form returns error

问题描述

我只想在Form的文本框中显示子表单的总计，但是它返回错误，尝试了多种解决方案，但是没有运气，甚至没有新查询.

I Just want to show totals from subform in a textbox on Form, but it returns error, tried multiple solutions but no luck, even a new query.

尝试了一些 Dsum ， Dlookup ， Sum 以及我用谷歌搜索但没有运气的其他解决方案，例如

Tried some Dsum, Dlookup, Sum and other solutions that I google'd but with no luck, like

=Sum([Pitanja subform1].[Form]![ID])
=Sum([Pitanja subform1].[Form]![Datum_prijema])

#Error

#Error

只希望在文本框中显示总计"值(如示例= 3) Broj upita

Just want "Total" value (like in example = 3) to be shown in textbox Broj upita

图片: https://ibb.co/9NBfnsF

推荐答案

在texbox子窗体页眉或页脚节中进行总和计算: = Sum([Datum_prijema]).该文本框不会在数据表视图中显示，但仍可供参考.

Do Sum calculation in texbox in subform header or footer section: =Sum([Datum_prijema]). The textbox will not show with Datasheet view but is still available for reference.

然后，主表单文本框引用子表单的文本框: = [Pitanja subform1] .Form.tbxSum

Then main form textbox references subform's textbox: =[Pitanja subform1].Form.tbxSum

这篇关于子窗体总计值到窗体中的文本框返回错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！