subform no data

N

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?
 
P

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?
Click to expand...

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

NetworkTrade

that works.

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