Count records in the recordset? - Access World Forums

Count records in the recordset? Modules & VBA ... i've got sql="Select Name, Transit from Table1 where Transit=" & varTransit Set rst = CurrentDb.OpenRecordset(sql1, dbOpenDynaset) Then I want to know how many records have been returned and assign that ..

www.access-programmers.co.uk