将过滤器传递给子表单 [英] passing filter to a sub form
问题描述
大家好,
我有一个子表单引用查询来获取结果。但是,
我想要做的是根据某个
标准进一步过滤结果。如何告诉子表单根据某个标准过滤结果。
我尝试使用设计器中的Filter和OrderBy字段,但是他们< br $> b $ b似乎没有影响!
谢谢,
Anja
" Anja < an ******* @ googlemail.com写信息
新闻:11 ********************** @ h48g2000cwc.googlegr oups.com ...
大家好,
我有一个子表单引用查询到得到结果。但是,
我想要做的是根据某个
标准进一步过滤结果。如何告诉子表单根据某个标准过滤结果。
我尝试使用设计器中的Filter和OrderBy字段,但是他们
似乎没有影响!
您还需要将FilterOn属性设置为True。您需要在代码
中执行此操作,因为该属性未在属性表中公开。
-
Rick Brandt ,Microsoft Access MVP
电子邮件(视情况而定)至...
在Hunter dot com的RBrandt
Rick Brandt写道:
" Anja" < an ******* @ googlemail.com写信息
新闻:11 ********************** @ h48g2000cwc.googlegr oups.com ...
大家好,
我有一个子表单引用查询到得到结果。但是,
我想要做的是根据某个
标准进一步过滤结果。如何告诉子表单根据某个标准过滤结果。
我尝试使用设计器中的Filter和OrderBy字段,但是他们
似乎没有影响!
您还需要将FilterOn属性设置为True。您需要在代码
中执行此操作,因为该属性未在属性表中公开。
-
Rick Brandt ,Microsoft Access MVP
电子邮件(视情况而定)至...
在Hunter dot的RBrandt com
感谢您的回复。如何通过
代码从VBA访问此子表单。
因此,在我的表单窗口中,我有2个表单。
>
按类别划分的交易和
" TransactionsByCategory_V"子窗体。类别表单是指
category_V子表单。
如何从代码中引用子表单?我尝试过
[Forms]![" TransactionsByCategory_V"] .FilterOn = true但是没有
似乎有效。它说找不到这张表格...
干杯,
Anja
< blockquote>
Rick Brandt写道:
" Anja" < an ******* @ googlemail.com写信息
新闻:11 ********************** @ h48g2000cwc.googlegr oups.com ...
大家好,
我有一个子表单引用查询到得到结果。但是,
我想要做的是根据某个
标准进一步过滤结果。如何告诉子表单根据某个标准过滤结果。
我尝试使用设计器中的Filter和OrderBy字段,但是他们
似乎没有影响!
您还需要将FilterOn属性设置为True。您需要在代码
中执行此操作,因为该属性未在属性表中公开。
-
Rick Brandt ,Microsoft Access MVP
电子邮件(视情况而定)至...
在Hunter dot的RBrandt com
感谢您的回复。如何通过
代码从VBA访问此子表单。
因此,在我的表单窗口中,我有2个表单。
>
按类别划分的交易和
" TransactionsByCategory_V"子窗体。类别表单是指
category_V子表单。
如何从代码中引用子表单?我尝试过
[Forms]![" TransactionsByCategory_V"] .FilterOn = true但是没有
似乎有效。它说找不到这张表格...
干杯,
Anja
Hi everyone,
I have a sub form that references a query to get the results. However,
what I want to do is filter the results further based on a certain
criteria. How can I tell the sub form to filter results based on a
certain criteria.
I tried using the Filter and OrderBy fields in the designer but they
seem to have no affect!
Thanks,
Anja
"Anja" <an*******@googlemail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...Hi everyone,
I have a sub form that references a query to get the results. However,
what I want to do is filter the results further based on a certain
criteria. How can I tell the sub form to filter results based on a
certain criteria.
I tried using the Filter and OrderBy fields in the designer but they
seem to have no affect!You also need to the FilterOn property to True. You need to do that in code
since that property is not exposed in the property sheet.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Rick Brandt wrote:"Anja" <an*******@googlemail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...Hi everyone,
I have a sub form that references a query to get the results. However,
what I want to do is filter the results further based on a certain
criteria. How can I tell the sub form to filter results based on a
certain criteria.
I tried using the Filter and OrderBy fields in the designer but they
seem to have no affect!
You also need to the FilterOn property to True. You need to do that in code
since that property is not exposed in the property sheet.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot comHi,
Thanks for replying. How can I access this subform from VBA through
code.
So, in my forms window, I have 2 forms.
"Transactions by category" and
"TransactionsByCategory_V" subform. The category form refers to the
category_V subform.
How do I refer to the subform from code? I tried doing
[Forms]!["TransactionsByCategory_V"].FilterOn= true but that does not
seem to work. IT says it cannot find this form...
Cheers,
Anja
Rick Brandt wrote:"Anja" <an*******@googlemail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...Hi everyone,
I have a sub form that references a query to get the results. However,
what I want to do is filter the results further based on a certain
criteria. How can I tell the sub form to filter results based on a
certain criteria.
I tried using the Filter and OrderBy fields in the designer but they
seem to have no affect!
You also need to the FilterOn property to True. You need to do that in code
since that property is not exposed in the property sheet.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot comHi,
Thanks for replying. How can I access this subform from VBA through
code.
So, in my forms window, I have 2 forms.
"Transactions by category" and
"TransactionsByCategory_V" subform. The category form refers to the
category_V subform.
How do I refer to the subform from code? I tried doing
[Forms]!["TransactionsByCategory_V"].FilterOn= true but that does not
seem to work. IT says it cannot find this form...
Cheers,
Anja
这篇关于将过滤器传递给子表单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!