Visible Subform .......

[Guest_imported]

I have problem with Subform. I don't know how to Subform visible when it is not data.

 

[ToeShot]

you can test to see if there is data for the form if there is do nothing but if there isn't then you can code the form to make it a data entry form.

To test for data:

If Me!Subform_Name.Recordset.Count = 0 Then
Me!Subform_Name.DataEntry = True
End If


HTH

 

[Guest_imported]

Thanks very much. Now I will do this.

 

[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 Subform visible when it is not data or data is null.