View Full Version : subform record count


nelslynn
12-12-2001, 10:44 AM
I have a subform based on a query. I want to only show the subform on the mainform when there are records that meet the query results.

How can I do this.

I am working in VBA at a change event for a combo box. I have:

Case select cboTrans
Case "B"
sfrm.requery
If (there are records---what do I put here---) Then
sfrm.visible = true

Jack Cowley
12-12-2001, 10:51 AM
If DCount("*", "QueryName") >= 1 Then