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 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!