Hi all,

I am using VB6 and i just cannot seem to get the RecordCount property of the recordset correctly. For example, when I tried using this property on form_load(), it always gives me a value of -1 even though the recordset contains 5 or 6 objects.

I need this property for two uses. Firstly to count and display the number of matching records found when the 'Search Results' form is loaded and secondly, to determine the no. of records left in the recordset when a record is deleted and if no record is left, then to close the form using form.hide method.

Can anyone please help me with this? Any help will be greatly appreciated. Thanks in advance for any help.