Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with a graph

Status
Not open for further replies.

poliv

Programmer
Jun 3, 2000
48
0
0
US
Hi,

I have a query when I put a field, to be iqual to a form field. That query works fine, but when I try to run a report having a graph based in that query it give an error, that Microsoft Jet not recognise [forms]![frm_rlt_graf]![cmb_sec] as a valid expression.
If I put in the query the field to be iqual to a number, the graph works fine!

Thanks
 
The form must be open when the report is run. Also, if the graph row source is a crosstab query, you will need to specify the data types of the query parameter. Select Query|Parameters and enter
[forms]![frm_rlt_graf]![cmb_sec] text (or whatever)


Duane
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top