I have been trying with no success to transfer a recordset from one form to another.
I have declared in Form1 that
Public myRS As ADODB.Recordset
All works lovely in Form1
In Form2 when I use
Private Sub cmdFail_Click(ByVal myRS As ADODB.Recordset)
I get an error message at runtime
Compile Error Procedure Declaration does not match description of event or procedure having the same name.
I have managed to get around the problem by stating all of my variables as Public in a Module, but from what I have read this may be poor practice.
Any help would be much appreciated.Thanks
P.S Does anybody find the ADO control even remotely easy to understand.:confused: