First, I would NOT use special characters ($) in an object name.
You don't have the correct syntax for referring to a form and it's controls. You have to start with the Forms! collection and drill down from there, and don't use brackets (unless you start a form name with such a special character or a number, which you also should not do):
Forms!frmHousekeeping.[8161StartADT$] And Forms!frmHousekeeping![8161EndADT$]
If there is a chance that the query could run with either control empty, or contain bad data (such as text when it should only be a number) you might want to consider preventing the errors or invalid query results (or none at all) that you may get.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.