In regaurd to the Check box, You can't have an unbound checkbox in a continuous form. What I have done in the past is create a tempary table with a yes/no(bit) field in it. Change your query to an append query and append that table. You will need to change your subform so that it calls the temptable instead of the query
Then you can add the check mark field to the form. The Report would then be based on a query from the temp table where the checks(bit field) are true.
You will want to call the delete and make table from a button
- docmd.setwarnings false
-
docmd.openquery "YourDeleteTempTableQryHere"
-
docmd.openquery "YourMakeTempTableQryHere"
-
docmd.setwarnings true
-
me.fsubyour sub Form.requery 'requry your subform so the new data shows.
For the Date you can place a start date and an end date on the form. In the query you can call the the date fields on the form.
- between [Forms]![your Form Name]![DateStart] and [Forms]![your Form Name]![DateStop]