On other forms/charts this code is working. For some reason this one keeps bombing out. I keep getting a 1004 run time error saying "Uable to Set the HasTitle property of the Chart class" This did work then it quit. I have Microsoft Graph 11.0 Object Libray selected in my references but don't think that has anything to do with it.
Here is my code:
Option Compare Database
Private Sub Form_Open(Cancel As Integer)
Dim Mychart As ObjectFrame
Set Mychart = Me!chrt
txt = "hello "
With Mychart
If Not .HasTitle Then
.HasTitle = True 'Bombs out here
.ChartTitle.Text = Form_frmmakereportbu.cmbbu.Value
Else
.ChartTitle.Text = Form_frmmakereportbu.cmbbu.Value
End If
.Refresh
End With
End Sub
Any thoughts? Is using the Microsoft Graph easier than using the chart Wizard?
Here is my code:
Option Compare Database
Private Sub Form_Open(Cancel As Integer)
Dim Mychart As ObjectFrame
Set Mychart = Me!chrt
txt = "hello "
With Mychart
If Not .HasTitle Then
.HasTitle = True 'Bombs out here
.ChartTitle.Text = Form_frmmakereportbu.cmbbu.Value
Else
.ChartTitle.Text = Form_frmmakereportbu.cmbbu.Value
End If
.Refresh
End With
End Sub
Any thoughts? Is using the Microsoft Graph easier than using the chart Wizard?
