One way is to play with the 4th argument (WhereCondition) of the DoCmd.OpenReport method:
strStartDate = "#" & Format(Me![Name of start date control], "m/dd/yyyy") & "#"
strEndDate = "#" & Format(Me![Name of end date control], "m/dd/yyyy") & "#"
strCriteria = "[Name of date field] Between " & strStartDate & " And " & strEndDate
DoCmd.OpenReport "Name of report", acViewPreview, , strCriteria
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244