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.
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.