Did some more testing, and I think it's actually the Table_RecordCount function. Here's the function I'm using:
Code:
Public Function Table_RecordCount(rs As DAO.Recordset) As Long 'Dim rs As DAO.Recordset
'Set rs = CurrentDb.OpenRecordset(sTable)
If Not (rs.EOF) Then
rs.MoveLast
Table_RecordCount = rs.RecordCount
End If
Set rs = Nothing
End Function
As you can see from the commented lines, this initially read in a table and performed the recordcount. Did I modify the function wrong? I want it to read in a recordset that I've already defined and give me the count.