Link multiple charts based on crosstab to a multiselect listbox and date in a form

[ErikaGu]

Hi,



I'm trying to have a form in which a user can make selections in a listbox and would be able to enter a date range to filter data in order to generate charts.
The thing is that the way I've built my project is: 1 form = 1 subject = 1 chart.
So, invidually, it works fine.

IE: If I wanted to know the status of the work done in the "Reg" department based on WorkerIDs, I could go to the "Reg" form and generate a chart.
If I wanted to know the number of absence based on AbsenceID, I could go to the "frmAbsence" and generate a chart for it.

However, I'm asked to create one single form in which a user can filter data and generate all charts.

How can I do this?

I've tried to set the Child/Master Link in the property of the second charts, but I'm having an error saying Microsoft Access doesn't recognize a field.

Thanks!

[ranman256]

the query would use the objects on the form:
qsFilter1Worker: select * from table where [dateFld] between forms!myForm!txtStartDate and forms!myForm!txtEndDate and [WorkerID] = forms!myForm!lstWorkID

the chart uses the query.
then when user changes the listbox selection, refresh the report

sub lstWorkID_afterupdate()
  me.Chart.requery
end sub

[ErikaGu]

the query would use the objects on the form:
qsFilter1Worker: select * from table where [dateFld] between forms!myForm!txtStartDate and forms!myForm!txtEndDate and [WorkerID] = forms!myForm!lstWorkID

the chart uses the query.
then when user changes the listbox selection, refresh the report

sub lstWorkID_afterupdate()
  me.Chart.requery
end sub

Hi ranman,

Thank you for the answer.

I'll try to implement the changes and will come back at you asap.

[ErikaGu]

Hi,

I added the following code to "qReg"

SELECT *
FROM tReg
WHERE [DatePlanned] between forms!frmReg!txtFromDT and forms!frmReg!txtThruDT and [WorkerID] = forms!frmReg!lstWorkID;

And the

sub lstWorkID_afterupdate()
  me.Chart.requery
end sub

But after selecting items from the listbox, the chart is not changing. Why is that?