Set graph rowsource to subform instead of table or query

[CoZak]

Hello, I havent found any help online or some complicated VB code that didnt work

Is there a way of plotting a Graph based on the values of a subform instead of a table or query?

I have multiple filters from comboboxes that filter the subform, not the query.
Also filtering the query in criteria with build with the value from the combobox : Forms![*User Interface]![subform_name].Form![combobox_name], doesnt work either



I tried the master/child technique with master: cbo_field child: [field]
And it works well but only for 1 combobox, i cannot add other fields or comboboxes with ";"

So i wanted to know if I could use the values inside the subform to dynamiccaly plot the chart


(ranman where are you )

Thanks in advance!

[ranman256]

suborms USE queries.

use the BUILDER to get the correct path to form/subform objects.
to use mulitiple controls, you must examine them all and build the where:

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 

sWhere = "1=1"
if not IsNUll(cboST) then sWhere = sWhere & " and [State]='" & cboST & "'"
if not IsNUll(cboCity) then sWhere = sWhere & " and [city]='" & cboCity & "'"
if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'"

If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If
end sub

[CoZak]

Hi ranman !
Thanks but the graphs only wants queries and tables, no matter how hard I try I cant get to make it work with a subform...