Based on your initial post I believe there is an issue with date format.
try using this
Between Format([Forms]![frmMain]![FirstDate],"m/d/yyyy") And Format([Forms]![frmMain]![SecondDate],"m/d/yyyy")
as for the sample database you posted as other have posted there are number of issues.
I am...