how to generate chart base on form

[lgjames]

I want to review chart report base on the form in which I can select date and other values.

I set the criteria for the query which the chart report based on. in the query I set criteria for "Date"= Between [Forms]![FrmReport]![BeginDate] And [Forms]![FrmReport]![EndDate], "salesperson"=[Forms]![FrmReport]![sales]...

but there is a problem when I open the report.

I can open query and see the data after I input value to the form, but when i open the chart report, it shows like this: "The Microsoft Jet database engine does not recognize '[Forms]![FrmReport]![BeginDate]' as a valid field name or expression."

the data report is working, but chart report is not.

how should I fix it!

thanks in advance

 

[dhookom]

I expect that your chart's Row Source is a crosstab query. If this is the case you must enter the data type of the query parameters.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]