查询表单中的未绑定字段..可能吗？ [英] query an unbound field in form.. Possible?
问题描述
我不知道这是否可行..我有一个表单frmCustomers有一个子表单sfrmCustomers
在子表单中我在页脚txtCOUNT中有一个未绑定的文本字段和控件来源
=总和（IIf（[行动] =收到来自，1,0））
和主要表格我有另一个未绑定的txt字段txtReceivedtimes
这只是为了快速参考，因为我正在通过客户梳理我看到他们有多少回报。
我想知道是否可以将txtReceivedtimes放入查询中。我的查询是从主窗体的表格中拉出来的，到目前为止我看到的是这样的。
I dont know if this is possible.. I have a form frmCustomers with a subform sfrmCustomers
and in the subform I have a unbound text field in the footer txtCOUNT with the control source of
=Sum(IIf([Action]="Received From",1,0))
and in the main form I have another unbound txt field txtReceivedtimes
It is just for a quick reference as I am combing through customers to see how many returns I have for them.
I was wondering if it were possible to get the txtReceivedtimes into a query. My query is pulling from the table of the main form and what I have so far looks like this.
推荐答案
从哪里[表格]！[跟踪注册]！[Receivedtimes]得出它的价值？你说它是未绑定的，所以它可能从某个地方获取一个值吗？如果它是一个计算控件什么是ReceivedTimes控件的控件源？它是DAggregate函数还是什么？
Jim：）
From where does [Forms]![TRACKING REGISTER]![Receivedtimes] derive its value? you say its unbound so is it grabbing a value presumably from somewhere? if it is a calculated control what is the controlsource of the ReceivedTimes control? Is it a DAggregate function or something?
Jim :)
从哪里来[形式]！[跟踪注册]！[Receivedtimes]得出它的价值？你说它是未绑定的，所以它可能从某个地方获取一个值吗？如果它是一个计算控件什么是ReceivedTimes控件的控件源？这是一个DAggregate函数还是什么？
吉姆:)
From where does [Forms]![TRACKING REGISTER]![Receivedtimes] derive its value? you say its unbound so is it grabbing a value presumably from somewhere? if it is a calculated control what is the controlsource of the ReceivedTimes control? Is it a DAggregate function or something?
Jim :)
对不起我想我出事了。它从子窗体的页脚中的txtCount获取其值。所有页脚txt字段正在进行的是用已接收字段对记录进行计数。在Action字段中。我只是想让该字段进入查询。
Sorry I guess I left that out on accident. It is getting its value from txtCount in the footer of the subform. All the footer txt field is doing is counting the records with "received" in the Action field. And I am just trying to get that field to go in the query.
如果从子表单中提取值，为什么不直接引用sql中的值directl。它应该类似于：
If the value is being pulled from your sub form why not just reference the value directl in the sql. It should look something like:
这篇关于查询表单中的未绑定字段..可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
