Button to execute graph data

[MFS]

Hello,
Ok, I'm trying to execute a query for a graph only after the form is open and a command button is pressed and not when the form is opening. See the graph is trying to search for data that hasn't been specified yet in my text boxes when the form is first opened, slowing the form down.

[June7]

Maybe leave the graph RowSource blank and use code to set and refresh.

[MFS]

I thought of that, but had some issues with the code.
I think I'll revisit that option again

[SMC]

I have a function like this in one of my databases. I use it to track Mill wear and cobble rates.
On my form I input two dates (default value is set to nothing) and then press a button which runs a query and then opens a report with graphs.

[MFS]

That is my current method, what happens is that when the form opens it tries running the Query searching for nothing.

[SMC]

My graph is opened in a new window. How important is it to have the graph on the form page? you could always have it open in another form or even a report I think.

[MFS]

Ahh, Ok, I see what you are saying. Sure!! I guess I could do it that way.
Thanks