You're on the right track...
Add this to the end of the execute statement
Set rsCand = .Execute(,,adOpenKeyset )