Passing a record set into a graph to display on a form

Hi Jens,

Thanks for your reply. Not quite - I have a query with 2 parameters. I wish to select the data and then this to be displayed on a graph as a subform.

is there any other information i can provide?

Manny

No worries Jens, I appreciate your help. I resolved it by setting up a query as the control source for the graph on a subform. this way whatever values are populated by the query are automatically fed into the graph :)

I do have one last query on this subject. In order to scale the graph accordingly, i need to get the maximum and minimum value ffrom the select query. the data is laid out like this..

[date] , [price1], [price2], [price3]

I would like to get the absolute maximum value and the minimum value of the entire query and then scale the graph accordingly. Currently using inputting boxes to manual type the scale, is there a way to get this from the query and then input into the iMax and iMin?

Private Sub Form_Load()

Dim iMax As Integer
Dim iMin As Integer

iMax = InputBox("Enter y-axis max")
iMin = InputBox("Enter y-axis min")

Me!Graph45.Axes(2).MaximumScale = iMax
Me!Graph45.Axes(2).MinimumScale = iMin

End Sub