You will probably have noticed that often the RecordCount method of the Data Control does not seem to work. The answer is that you need to goto the end of the records before it can tell you how many there are! Here's the code.
Data1.Recordset.MoveLast
Msgbox "Record Count: " & Data1.Recordset.RecordCount
Comments