Shep,
On your frmReportDateRangeV1 form, as well as the controls for the date
range selection, you can put an unbound combobox, where the Row Source
will be based on the list of Contacts. Probably the most commonly used
approach here would be 2 columns in the combobox, with ContactID and
ContactName, with Column Widths property set so that ContactID is the
bound column but hidden and ContactName is displayed. Let's say this
combobox is named ContactSel, then in the query for the report, you will
put this in the Criteria of the ContactID field...
[Forms]![frmReportDateRangeV1]![ContactSel]
... and thus the Where clause of the query's SQL will look something
like this...
WHERE (((Calls.CallDate) Between
[Forms]![frmReportDateRangeV1]![Start Date] And
[Forms]![frmReportDateRangeV1]![End Date]) And
((Calls.ContactID)=[Forms]![frmReportDateRangeV1]![ContactSel]))

Signature
Steve Schapel, Microsoft Access MVP
> MS Office 2003 Pro
>
[quoted text clipped - 33 lines]
>
> Thanks
shep - 25 Dec 2005 20:10 GMT
Thank you very Much; Just what I needed
> Shep,
>
[quoted text clipped - 51 lines]
> >
> > Thanks