Date Filter to Crosstab Error

[Bkndbrown]

I have a query that filters entries between dates that are entered on a Form called FLegalLanding


the criteria formula I am using is "between [forms]![flegalLanding]![StartDateRng] and [forms]![flegalLanding]![EndDateRng]"
This query works with no problems. I then go through another query and a union to manipulate the data and combine two queries. Again the output of these queries all work just fine.
The only place in all of these queries that have dates or reference to the filtering is the original query

Finally my Union feeds a query that is only there to turn it into a crosstab table.
When I run this crosstab query I get an error
"The Microsoft Access database engine does not recognize '[forms]![flegalLanding]![StartDateRng]'as a valid field name or expression."

If I remove the criteria then the cross tab will work, if I replace that criteria with "between date() and date-120" it works (however this does not really solve my problem because I need to be able to change the dates).
I tried changing it to "between [Enter Start Date] and [Enter End Date] and again all of the forms would work except for the cross tab which through about the same error.

I'm sure I am missing something easy but I have gone through everything I could think of.

[ranman256]

ALL queries involved in a crosstab MUST have parameters entered.

so in the base query using : between [forms]![flegalLanding]![StartDateRng] and [forms]![flegalLanding]![EndDateRng]"
in qry design, click the PARAMETERS button and enter:
[forms]![flegalLanding]![StartDateRng] date/time
[forms]![flegalLanding]![EndDateRng] date/time

save qry.

all other queries in your union must have it to if it is used in the Crosstab. It's their thing.

[Bkndbrown]

Thank you I knew I was missing something stupid. That worked great.