subform no data

[NetworkTrade]

If the query that the subform is sourced on, returns no records, the subform
will be blank.

I would like in this situation for a nonvisible label "No Data" to be made
visible. Is there a NoData function that one can use in this situation?

 

[Piet Linden]

If the query that the subform is sourced on, returns no records, the subform
will be blank.

I would like in this situation for a nonvisible label "No Data" to be made
visible.  Is there a NoData function that one can use in this situation?

What if you get a recordcount of the subform's recordsetclone?

 

[NetworkTrade]

that works.

was wondering whether the HasData function exists for Forms but I guess it
is only for reports/subreports...