Opening a recordset using ADO

I've been programming in Access for a number of years using DAO, I must say ADO connections are getting the best of me.  this code did work, now it is not.  Please help, I don't know what I'm doing w...