Filter a crosstab query

I have a large crosstab query.  I need to filter the records returned based on batch number.

In the batch number column, if I type, forms!frmBatch!cboBatchSelect, where the combo box on the form holds the batch number, I get an error message.  The message advises that jet doesnt recognize the expression or field.

If I type in Like Forms!frm... etc I still receive the same error.

If I type in Like 260, where 260 is a batch number, the correct records are returned.  I am sure the syntax for referring to the combo box is correct and doesnt contain any typos.  What am I doing wrong there.

The other problem I have is, that there are five columns on the report, based on the crosstab query, that sometimes don't exist in the records returned from the query.

For example, there may be a field on the report called Terms.  The crosstab may not return that column when the records are filtered.  I consequently get an error advising that the field is not recognized and the report subsequently crashes.  How can I code for these five columns to be ignored if the underlying records don't have a matching column.  If that's possible?

so, two problems above which are driving me to despair!

thanks for your help
Start Free Trial