Form field for criterea problems

[Bdavis]

I have query with the following criterea in the date field [Forms]![Frm - MMR
Form]![RunDate].

I copied this from another query that works perfectly. But, I get an error
that says the Jet database does not recognize this feild. I can't figure
this out. Any ideas?

The form is open and populated and all other queries using this identical
criterea work fine.

 

[Ofer]

I would check again the the name of the field in the form.


If the field is in a subform then the path should be different

Forms![MainFormName]![SubFormName].Form![FieldName]
Just incase

 

[Bdavis]

It's not in a subform. This criterea is literally cut and pasted out of
another query which works just fine. The only other difference between these
two queries is the problem query is a cross-tab.

I would check again the the name of the field in the form.


If the field is in a subform then the path should be different

Forms![MainFormName]![SubFormName].Form![FieldName]
Just incase



--
I hope that helped
Good luck

I have query with the following criterea in the date field [Forms]![Frm - MMR
Form]![RunDate].

I copied this from another query that works perfectly. But, I get an error
that says the Jet database does not recognize this feild. I can't figure
this out. Any ideas?

The form is open and populated and all other queries using this identical
criterea work fine.

 

[John Spencer (MVP)]

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2