View Full Version : Form critera in chart


lcline
02-05-2004, 04:51 AM
Please help!

I have created a chart on a form based on a query with critera tied back to the form. Everything worked great. I now wanted to do the same for a different table. I went though the same steps as I did the first time (create query, built link to form objects, created the chart), but for some reason I keep getting an error that states that [Form]![theform]![txtbeg] as a valid name or expression. I hard coded the critera in the expression for this variable and then it failed on the next form object.
I tried coping the one that works and change the table in the query, but it still fails.

What am I doing wrong? My boss needs this today.

Thanks in advance.

Rich
02-05-2004, 06:15 AM
You probably need to define the Graphs underlying query parameters

lcline
02-05-2004, 11:12 AM
What I did is I went to the chart properties, data, row source and clicked ... I then used the build option to link the query to the text fields in the form that held the criteria. then when I opened the form, I got the stated error that is above.

This is exactly what I did on the first chart I created and it works, I just can't understand why this one does not.