Recordsets as Parameters!?

will

Registered User.
Local time
Today, 08:59
Joined
Jul 11, 2001
Messages
18
Hello,
I want to be able to pass a recordset as a parameter within a function, and to be able to alter and perform operations on that passed recordset.
Here is the code that I am using that is currently giving me an "error #13 type mismatch":

Public SubCloseifNeeded(rsRecordset as ADODB.Recordset)
If rsRecordset.EOF = False and rsRecordset.BOF = False Then
'null
Else
rsRecordset.close
end sub

The type mismatch occurs whent the routine is called from a different form. Any help you can give would be useful!
 
I'm trying to determine if there are any records within the record set but rather whether or not the record set it open. Furthermore if it is open I want to close it. Otherwise I want to leave it closed
 
I'm trying to determine if there are any records within the record set but rather whether or not the record set it open. Furthermore if it is open I want to close it. Otherwise I want to leave it closed
 

Users who are viewing this thread

Back
Top Bottom