I am wondering how I can determine if a Select statement in VBA selected any records.
Ie. Return the number of records selected to a variable.
If you want the exact number of records, use something like this:
Public Function test()
Dim rs As Recordset
Dim NumberOfRecords As Long
Set rs = CurrentDb.OpenRecordset("SELECT * FROM JOB")
If Not rs.EOF Then
NumberOfRecords = rs.RecordCount
Set rs = Nothing
but if you just need to know if any records came back, just check the recordsets EOF property