Is the Private in the "General declarations" section and the set into a procedure?
DO you have a reference to ADO (or DAO)?
>Hi All,
>
>How come I get a compile error: Invalid use of New keyword on this code:
>
>
Private mrsCon as Recordset
>Set mrsCon = New Recordset
>
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com