I use entries in forms to provide selection information in queries.  I
noticed when I call a Cross Tab Query (criteria either in the Cross Tab or
in a query the Cross Tab calls) the Cross tab complains about the criteria
(I.E. Between [Forms]![frmLizTest]![StartDate] And
[Forms]![frmLizTest]![EndDate]).  Parameters do not seem to work either.

To work around this I put the criteria in the regular query and build a
table with it.  A single button in the form deletes the old temporary table,
builds the new on and the Cross Tab Query now pulls this information from
the new table without problems.

This seems rather bothersome to have to call out knight Sir "Qitus".

Any ideas on how to simplify this.

Mike Marcus, IT DBA
Nelson Publishing, Inc.