Subform to disappear depending on whether it contains data.

[LOUISBUHAGIAR54]

How do i set a subform to appear/ disappear on whether the subform contains/ does not contain records ?

 

[G37Sam]

Lets say your subform contains the orders of your Clients. I would put the below in the form's Current event.

If dlookup("count(*)","Orders","ClientID = " & me.ClientID) = 0 then
    me.OrdersSubform.visible = false
else
    me.OrdersSubform.visible = true
End if

 

[Mimadocken]

I have much less experience than many of the people replying here, but when I want a field or a subform not to appear if there's nothing there, I've always set the "Can Shrink" property on the Format tab of the Properties to "Yes."

There may be instances where this won't work, but it has worked for me.

 

[LOUISBUHAGIAR54]

I like both replies. I have tried to set can grow and can shrink properties to the subform to yes, but the form still show with no data.

The DLookUp option is more promising and I will try it. Could you explain the function to me and how it works please.

LouisB

 

[G37Sam]

A good reference to how dlookup works: http://msdn.microsoft.com/en-us/library/office/aa172176(v=office.11).aspx

Using count(*) in dlookup returns the number of records