Generating graph from continuous form

[Matt89]

Hi guys,



thanks for reading this post. I'm kinda new here, so bear with me

I got a continuous form (referred as Form1) which has a dropdown and a few textboxes to generate a filter for the from. There are also two command buttons, one for filtering the data, one for generating a graph in Form2.

The problem is with generating the graph. I'd like to use the form's filter for bounding the graph's data. So all records shown in Form1 must be used for the new graph (Graph1 in Form2). Is there a way to copy the filter to the new form or use the data?

I know that this is explained quite weirdly, but I cannot think of another way at this moment.

Thanks!

[June7]

VBA could set the RowSource property of the graph.

Why is the graph on a separate form? Do you want to provide project for analysis?

[Matt89]

VBA could set the RowSource property of the graph.

Why is the graph on a separate form? Do you want to provide project for analysis?

FYI, because we want to display the records first in the continuous form and then generate a graph out of it in a seperate view to have buttons for previewing, printing and closing. The previewing is a prerequisite.

And I did not catch your last sentence, unfortunately.

[June7]

Do you want to provide the project for analysis? Attach to post and I will download.

Make copy, remove confidential data, run Compact & Repair, zip if large. Attachment Manager is below the Advanced post editor.

Otherwise, could upload to fileshare site such as box.com and post link to file.

For print purpose, might be better to use a report.