[RESOLVED] Object variable or with block variable not set

[DubweiserTM]

If you have "hidden" some off the code, you must post it. We are only able to go on what you post. In it, you set rs = new adodb.recordset at the start of the code, not each time you needed it. Maybe, you are carrying some 'memory-residual' bits. By setting it to nothing when you close it, it should be cleared from memory. However, that implies that you will need a "set rs = new adodb.recordset" the next time you wish to open rs.

Here is the missing part of code, sorry !

'Vider les paramètres
        Set rs = Nothing
        Set cn = Nothing
        
        'Fermeture de la Form
        Unload Me