If all you want is to be able to pick customers for the report without
keeping a permanent record of who was picked when, the yes, add a yes/no
field to your table to you can click the records you want. You can then
create a query where this field is True, and use is as the Record Source for
your report.

You probably want a button on your form to reset all boxes to Off again. If
so the event procedure would look like this:
   Private Sub cmdResetAll_Click()
       Dim strSql As String
       If Me.Dirty Then Me.Dirty = False    'Save any changes first.
       strSql = "UPDATE Customers SET IsPicked = False WHERE IsPicked =
True;"
       dbEngine(0)(0).Execute strSql, dbFailOnError
   End Sub

If you want to keep track of who was picked when, you will need another
table with fields like this:
   CustomerID    relates to the primary key of your Customers table.
   PickDate         date/time field, with Default Value set to:  =Date()

You can add records to this table, and then create a query joining this and
the Customers table, with Criteria on the PickDate field to limit it to
those picked on a particular date.

Neil,

Along the lines of what you are trying to do, I have a calendar report
module that shows sales calls for any month you select in the calendar. I
could implement this in your database for you for a very reasonable fee. If
you are interested, contact me at my email address below and I will send you
a screen shot of the calendar report.