Crosstab Query Misbehaving 1

[tomco22]

Is there a trick to get my Crosstab query to read a text box from a form. I am trying to limit the date range to a calendar month in my Crosstab query. It works fine if I hard code the dates but I am striving for dynamic. The following is a date field:

Criteria: >=([Forms]![frmReports]![txtFirstOfThisMonth]) And <([Forms]![frmReports]![txtFirstOfNextMonth])

I’ve tried having the Crosstab query draw from a another query that has this date range but I get the same message, “The Microsoft Jet database engine does not recognize ‘[Forms]![frmReports]![txtFirstOfThisMonth]’ as a valid field name or expression.” I DO have the reference form open and the text boxes formatted as "Short Date". Any ideas?

Tom
MCSD
I Nab Terrorists

 

[RoyVidar]

Try the following:
In the query design select Parameters from the query menu. Enter both form references and their datatype.

Roy-Vidar

 

[Wrathchild]

thanks RoyVidar! I had to walk out of work yesterday and cool off becuase I was getting so frustrated on this one. Have a twinkler!