I have a query that pulls specific data based on the manager selected in a combo box. I am trying to creat two reports from this data, one that shows the data in number format(this one works as expected), and one which shows the data charted. When I try to run the chart it give a Jet Database error saying that [Forms]![Team Lead Selection]![Combo0] is not recognized as a valid field name or expresion. How do I work around this?
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional Data In Charts
- Thread starter mbthaz
- Start date
Hi,
The problem may be with your line of code:
[Forms]![Team Lead Selection]![Combo0]
Instead of that try this:
[Forms]![Team_Lead_Selection]![Combo0]
If that doesn't work try renaming your form name to something without spaces. Sometimes VB has problems with spaces in the form names.
jbehrne
The problem may be with your line of code:
[Forms]![Team Lead Selection]![Combo0]
Instead of that try this:
[Forms]![Team_Lead_Selection]![Combo0]
If that doesn't work try renaming your form name to something without spaces. Sometimes VB has problems with spaces in the form names.
jbehrne
- Status
Similar threads
