I am not sure, but look in the first gray box of code, at the top of the page, at the last line before . Should this be instead of ? It just seems that, if I am understanding the code correctly, "OpenRecordSetADO" and "CreateConnectionADO" are variables and "CreateConnectionADO" has not been declared, and "OpenRecordSetADO" has been declared but not used. Please let me know if I am wrong, and why the code works the way it is.

Hello poohbearmama657,

Thanks for your post here, it looks like the first post you made in these forums and we really appreciate the time and effort you've taken here to make this post. Also, and more importantly, you have uncovered an error in the book and I wanted to say thanks for pointing this out, this is actually a mistake in one of my chapters (though the source code download from the website has the correct code)!

Specifically, on page 194, the code "Set CreateConnectionADO = rs" is actually incorrect. The code should actually be "Set OpenRecordsetADO = rs", because this line of code is assigning the recordset object that was created to the function, to return the recordset to the caller of the function.

It is truly unfortunate that this error made it into the book, the source code on the Wrox P2P download site should be correct. Also, I have added this to the list of errata items for this book and again, I want to thank you for taking the time to point out this issue, I hope it has not caused any inconvenience for you.

Sincerely,

Geoffrey L. Griffith
Co-Author of the Access 2007 VBA Programmer's Reference
http://www.ImagineThought.com