Crosstab based report - linking criteria from an unbound form

[barrygraham]

Hi there, I have a report based on a crosstab query, which lists students attendance figures. There are aprox 2800 students listed in the query. The problem I am having is that I cant seem to set a linkcriteria from an unbound field on a form to filter the data on the report.

Every student has their details on a single page on the report, and I would liketo filter by: INV student, tutor, faculty, centre etc. I have created list boxs and combo boxs (based on queries) with the required data needed to link to the report, (I have used this method before on other reports not based on crosstabs)but I keep getting the error message "Jet engine does not recognise <field name> as a valid field name or expression. This has got me really stumped as I have used linkcrieria's as strings to open filter reports many times in the system without any problems.

Does anyone know if this is due to the report being based on a crosstab query? I cant seem to find any literature that can help me on this subject. Any help would be greatly appreciated.

Thanks in advance, Barry Graham

 

[barrygraham]

Hello, me again.

I feel I should add that the unbound form that I mentioned is a "Print Menu" for the report. It is essential that users be able to view/print this report by certain catagories/filters. I have thought of opening up the querydef and using a case select for this, but as there are 10 "print options" that I need I would like to avoid this if possible. If this is the only way, could you please provide some sample code that would make the case select easier?

Thanks again. Barry Graham