Using A form to filter records displayed on a report

I am trying to use a form(frmCPJECD) (pic attached) to filter records displayed on a report the search button runs a macro opening the report and it is supposed to filter out records depending what has been typed into frmCPJECD.
View attachment frm.doc

I have used the expression builder in the macro's design view, but keep getting the Enter Parameter value box after clicking the Search Button(see attched) View attachment parameter values.doc

This is what is in the where condition field in the macro's design view.

[qryCPJ]![Progress Journal Start Date] Between [Forms]![frmCPJECD]![DF] And [Forms]![frmCPJECD]![Date To] And [qryCPJ]![Enterprise Champion]=[Forms]![frmCPJECD]![EC] And [qryCPJ]![Progress Journal Started]=[Forms]![frmCPJECD]![T]


Any Help would be very much appreciated

from the looks of your criteria, your report is based on a query. I prefer to place the criteria into the query then you don't need a macro, just add a button to open the Report.

for the date range criteria use:

>=([Forms]![frmCPJECD]![DF]) And <=([Forms]![frmCPJECD]![DT])

and the other fields use this syntax...


[Forms]![frmCPJECD]![EC]