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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart on form wont use the underlying query??

Status
Not open for further replies.

pmo

Technical User
Jan 15, 2001
76
AU
My form consists of 1 chart. The form its self is not bound to a table or query. The chart however uses information from a query.
If I filter the query by putting a filter in the grid as normal everything works fine.
If I add an [Enter Name] to the grid or a reference to a form [Forms]![ReportF]![Combo65]to the grid I am prompted with "The jet database engine does not recognise [Enter Name]as a valid field name or expression. It then continues to the form without displaying the graph.
If I run the query on its own all works with no problem and I am prompted with [Enter Name].
Can anyone help?

Wayne
 
You need to a global variable for the information on the form. I had the same issue. Then put YourInformation() in the criteria of the query.

YourInfo=[Forms]![frmYourForm]![Combo65]

Function YourInformation() As String
YourInformation = YourInfo
End Function

John Green
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top