See attached which is a sample demo of my problem.
I want a "crosstab" report showing a count of all the cars in my town.
However only cars made after 1999 should be included.
1. Run FORM1 and put 1999 in for the year.
2. Then click "Crosstab Query" which calls Query1 which in turn calls Query1_Crosstab.
See error http://screencast.com/t/XvawZhC8Kan
The system seems to object to ">[forms]![Form1]![YearChe
ck]" in QUery1. However, this works when run as a simple query.