Opening Continuous Form as Report

[chathag]

I have a continuous form set up that returns data on over 100 records. I have set up a command button that opens the form in a report template.

The following code triggers the report:

DoCmd.OpenReport "Rpt_Test", acViewPreview, , "[cohort] = [Forms]![frm_pupil_dets_ndcArea]![NCY]"

The problem I have is when the report opens only the first set of data from the form appears. I have checked the properties within the report to see if there is a "continuous" option but there does not seem to be one.

Any help would be appreciated

Chathag

 

[KenHigg]

I would suggest doing a report for printing and not a form