set graph resource and define date criteria vba

[arnelgp]

You already has the date criteria in qry_RMS_ReturnReason1 which is pointing to your form, all you need to do is Requery the grapg control.

 

[aman]

I have figured it out. I just had to define the query parameters in cross tab query for Forms!frm_RmS_dashboard!txtDateStart and Forms!frm_RmS_dashboard!txtDateend

 

[JHB]

I wrote that in post #13.