Subform not visible

[Guest_imported]

I can't do this. Because Record source (in my Subform) is a query for calculate.

Example: Record source = SELECT SUM(PP_AMOUNTUSD) AS PAIDUSD, SUM(PP_AMOUNT) AS PAIDVND, SUM(PP_AMOUNT / PP_ER) AS PAIDEQUSD, PO_ID FROM PROJECTPAYMENT GROUP BY PO_ID

How to do Subform visible when it is not data or data is null.

 

[Haitham]

Hi Ger_VN,

Try in your main Form this
If Me.[Yoursubformname].Form.RecordsetClone.RecordCount > 0 Then
else
If Me.[Yoursubformname].Form.RecordsetClone.RecordCount = 0 Then
me.Yoursubform.Visible = False
end if
end if

Good Luck

 

[Haitham]

Hi Ger_VN,

Sorry For Missing One Line

If Me.[Yoursubformname].Form.RecordsetClone.RecordCount > 0 Then
me.Yoursubform.Visible = True
else
If Me.[Yoursubformname].Form.RecordsetClone.RecordCount = 0 Then
me.Yoursubform.Visible = False
end if
end if

Good Luck

 

[Guest_imported]

Thanks very much. I will try again.