Recordcount

Why doesn't this work????

'Checks to see if data in MakeTable
strSQL = "SELECT * from [T_Audit_MakeTable]"
recMakeTable.Open strSQL, cnnRetDtbse, adOpenDynamic, adLockOptimistic

If recMakeTable.RecordCount < 1 Then
Beep
MsgBox "No records available for the selected month.", vbOKOnly
Screen.MousePointer = vbDefault '
Unload Me
Exit Sub
End If

'''I keep getting a -1 for recordcount even though I know that the table has records. No matter what I've tried, I get -1.....WHY??? :huh:

Please help....Thanks :D

use one of the move methods to move to the end of the recordset before calling the recordcount property.

Set the connection to use adUseClient for the CursorLocation property before you open the connection and the RecordCount property should work properly.

If recMakeTable.BOF And recMakeTable.EOF Then

Is the more proper way to check for an empty recordset.

Thanks for all of your help!!! Merry Christmas to all!!!!