I have a chart on a form that is run by a query: "ChartQuery"
the select statement is as follows:
SELECT Input.[In], Targets.TargetIn, Metrics.AccMeasure, Metrics.ExeMeasure, Input.Date
FROM Job INNER JOIN (Employee INNER JOIN ([Input] INNER JOIN (Targets INNER JOIN Metrics ON Targets.Measure = Metrics.Measure) ON Input.Measure = Metrics.Measure) ON (Employee.EmpNo = Input.EmpNo) AND (Employee.EmpName = Targets.EmpName)) ON (Job.JobNo = Targets.JobNo) AND (Job.JobNo = Metrics.JobNo) AND (Job.JobNo = Input.JobNo)
WHERE (((Input.Measure)="Absenteeism (shift)") AND ((Input.EmpNo)=5) AND ((Input.JobNo)=2));
its long, i know, but it works
towards the end of the query where you see:
Firstly, i want "Absenteeism (shift)" to be a value read from a combo box.
Secondly, after update of the combobox that value must change and hence the chart must change too.
how would i go about doing this?
any help will be greatly appreciated.