Chart based on form based parameter query

[wordsmith]

Hi all,

stuck on this, not sure if it can be resolved....

I have a parameter query for which the parameter is based on a form field entry (i wanted to avoid the dialog box popping up).

No problems with this....however, I want to create a chart based on the same query however, i get the following error message because it does not recognise the query parameter.

Error Message: The Microsoft Jet database engine does not recognise '[Forms]![frmChooseDTDate]!DateOccured' as a valid field name or expression.

Can this be resolved?

Help most appreciated!

regards to all

K

 

[Rich]

Have you defined the query Parameters ?

 

[wordsmith]

Hi Rich,

thanks for responding.

sorry still quite novice on this so unsure what you mean by defined the query parameters.

does that mean that in the design view of the query, in the query menu, there is a parameter option which brings up a query parameters dialog box. which has Parameter and Data Type?

If so, I was unsure what to put there.

should I put the form entry parameter: [Forms]![frmChooseDTDate]![DateOccured] under "parameter" ? and if so, what is the data type?

regards

Keji