The object oCnn has not be declared (or initialised!). You should generally either use DAO (your db variable) or ADO (your oRs variable), but not both.

For an example of setting up an ADO connection, see the ADO Tutorial link in my siganture.


Oh, and the VBCode tags on this forum need to be like this:
[vbcode]code here[/vbcode]