Is this possible to pass two recordsets to another sub??? I assumed using the code ...
-------------------------------------
dim rs1 as dao.recordset
dim rs2 as dao.recordset
code...
code...
bulkSelect (rs1, rs2)
Pass to another sub
Public Sub bulkSelect(rs1 As dao.recordset, rs2 As dao.recordset)
--------------------------
However, loading the method is fine but when the call is made, an error occurs, " Compile error, Expected: = "
Any help appreciated.
Shaun.
-------------------------------------
dim rs1 as dao.recordset
dim rs2 as dao.recordset
code...
code...
bulkSelect (rs1, rs2)
Pass to another sub
Public Sub bulkSelect(rs1 As dao.recordset, rs2 As dao.recordset)
--------------------------
However, loading the method is fine but when the call is made, an error occurs, " Compile error, Expected: = "
Any help appreciated.
Shaun.