This is what I know so far.
I have the code and every thing set up to go. The only problem is that I cannot get the graph to look at the VBA to define the graph. I think that I need to put something in the row Source Type field or the Row Source field to get it to look at the VBA in access.
Any idea please?
My code
Private Sub MyGraph_Enter()
Dim TableName As String
TableName = Me.Graph_Selected_Table
strSql = "SELECT [LOAD], [Displacement] FROM " & TableName
End Sub
I have the code and every thing set up to go. The only problem is that I cannot get the graph to look at the VBA to define the graph. I think that I need to put something in the row Source Type field or the Row Source field to get it to look at the VBA in access.
Any idea please?
My code
Private Sub MyGraph_Enter()
Dim TableName As String
TableName = Me.Graph_Selected_Table
strSql = "SELECT [LOAD], [Displacement] FROM " & TableName
End Sub
Last edited:
