Hide sub form

[ironwood9 via AccessMonster.com]

My subform, named sFrmTime, is sourced by the query sQryTime - I want to hide
the sub form if the sub query returns zero, but the following code in the
Current event of my form doesn't work. Any ideas ?

If Nz(DCount("*", "sQqrytime"), 0) > 0 Then

Me.sFrmTime.Visible = False
Else

End If

 

[Dirk Goldgar]

In

My subform, named sFrmTime, is sourced by the query sQryTime - I want
to hide the sub form if the sub query returns zero, but the following
code in the Current event of my form doesn't work. Any ideas ?

If Nz(DCount("*", "sQqrytime"), 0) > 0 Then

Me.sFrmTime.Visible = False
Else

End If

Is that really the code you're using? It would seem to be hiding the
subform if the query does return records, not the other way around.
Have you tried this:

Me.sFrmTime.Visible = _
(Me.sFrmTime.Form.Recordset.RecordCount > 0)

?

 

[ironwood9 via AccessMonster.com]

right - I had it backwards - thanks !

My subform, named sFrmTime, is sourced by the query sQryTime - I want
to hide the sub form if the sub query returns zero, but the following

[quoted text clipped - 6 lines]

End If

Is that really the code you're using? It would seem to be hiding the
subform if the query does return records, not the other way around.
Have you tried this:

Me.sFrmTime.Visible = _
(Me.sFrmTime.Form.Recordset.RecordCount > 0)

?