subform record count (1 Viewer)

nelslynn

Registered User.
Local time
Today, 11:24
Joined
Oct 8, 2001
Messages
40
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
 

Users who are viewing this thread

Top Bottom