Sounds like a frustrating experience!
Since you've found the key to comparing dates - using the hash (#) - I'm going to suggest that you're overlooking something obvious.
Take a good look at strWhere just before you set the RecordSource and make sure it is ALL built correctly. Make sure you have balanced parenthesis. Make sure that there is a boolean operator (e.g. "AND" or "OR") between each of your comparisons. And make sure the dates within the hashes are valid dates. E.g. #2/30/2005# is not a valid date.
Your example is perfect SQL syntax. But if you concatenate that with what you already have in strWhere without putting in a boolean operator before the date comparison, the syntax will be wrong.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group