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
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