Show/Hide Label

[midiman69]

I have a tab control form with a subform (qrybomsubform)
I wish to show a warning message on the main form if the field Currcosttotal on the subform = zero (not Null - zero)
I have the following - this hides the label but doesn't show it when I move to a record with a zero value.
Currcosttotal is formatted currency to 4 decimal places and contains either a value or zero.

Can any one help??

Private Sub Form_Current()

If Forms!frmprojectstabbed!qrybomsubform.Form!Currcosttotal.Value = 0 Then
Me.test.Visible = True
Else
Me.test.Visible = False
End If

End Sub

 

[yummy7]

Try this
If IsNull(Forms!frmprojectstabbed!qrybomsubform.Form!Currcosttotal.Value) Then

 

[midiman69]

Thanks Yummy - still only hides the label and doesn't show it when Zero value on subform

Private Sub Form_Current()
If IsNull(Forms!frmprojectstabbed!qrybomsubform.Form!Currcosttotal.Value) Then
Me.test.Visible = True
Else
Me.test.Visible = False
End If

Dave

 

[yummy7]

Also change the event of Form_Current to Form_Load. Actually dave I can help you but not esure of solution,because i m also new in Access.You can check either your if condition is rigt by replacing Me.test.Visible = True with MsgBox("True/False").
Also Debug it to check the value of Currcottoal.ok