Determine Number of Rows returned in a Query

[jmgibson]

Hi,

I suspect this is easy for many, but I can't figure out the necessary vba code to execute a requery and determine how many rows were returned in the query.

Here's the basic gist of what I'm doing. Do I need to declare anything to use the RecordCount feature?



Private Sub Form_Current()
If qryresults.RecordCount = 0 Then
Me.TabCtl4.Pages(3).Visible = False
Else
Me.TabCtl4.Pages(3).Visible = False
End If

End Sub

 

[dhookom]

This is the same question as thread181-1542583. I don't know where else you have posted this but I didn't see it in the Queries forum where it should be.

Please post your question in the single, most appropriate forum.

Duane
Hook'D on Access
MS Access MVP