子表单中的总问题 [英] Total problem in subform

问题描述

我有一个formA和子表单B

subformB是一个连续的表格

，表格页脚为txtTotal

=总和（[总计] ）

只要表格中有

记录就可以正常工作

但如果表格为空我会收到错误

我想得到这个，因为我

有一个标签只有可见

如果txtTotal> = 45000

它的方式它现在标签显示可见

表格上没有记录

感谢您的任何建议

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])
This works fine as long as there are
records in form
but if form is null I get Error
I would like to get arround this as I
Have a label to be Visible only
if txtTotal>= 45000
The way it is now label shows up visible
on form when it has no records
thank you for any suggestions

推荐答案

肯，


尝试根据以下内容显示方框


如果不是IsNull（我。 txtTotal）和Me.txtTotal> = 45000然后


Me.txtTotal.Visible = True


结束如果


Linda


" ken" <柯****** @ yahoo.com>在消息中写道

news：11 ********************* @ g44g2000cwa.googlegro ups.com ...

Ken,

Try making the box visible based on the following

If Not IsNull(Me.txtTotal) and Me.txtTotal>=45000 Then

Me.txtTotal.Visible = True

End If

Linda

"ken" <ke******@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

我有一个formA和subformB
subformB是一个连续的形式
带有一个txtTotal形式页脚
= Sum（[Total]）
这个工作正常，只要有是形式的
记录
但是如果表格是空的我得到错误
我想得到这个因为我
标签只有可见
如果txtTotal> ; = 45000
现在标签的方式在没有记录的情况下在表格上显示
感谢您的任何建议

I have a formA and subformB
subformB is a continous form
with a txtTotal in form footer
=Sum([Total])
This works fine as long as there are
records in form
but if form is null I get Error
I would like to get arround this as I
Have a label to be Visible only
if txtTotal>= 45000
The way it is now label shows up visible
on form when it has no records
thank you for any suggestions

尝试过但仍然无法工作

tried it and still not working

Private Sub Form_Current（）

Me！txtTotal.visible = Nz（Me！txtTotal，0）> = 45000

End Sub

厚重的Quinker - 我从不学习。


***通过开发人员发送的指南 http：//www.developer sdex.com ***

Private Sub Form_Current()
Me!txtTotal.visible = Nz(Me!txtTotal,0) >=45000
End Sub
Thick Quinker - I just never learn.

*** Sent via Developersdex http://www.developersdex.com ***

这篇关于子表单中的总问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！