embed chart in report using VBA

M

mark

hi.

I'm trying to prog. VBA to embed a chart in a Report in Access. I can create an unbound object frame and a MS.Graph chart object but i can't set the frame to reference the object. I've tried setting the ctrl's Object propery but it won't work. I've tried setting the ctrl's OLEType property to Embedded (1) but it is read only. How do i embed the Graph object

I need to embed the graph using vba since it must be automatic
thanks!
 
Top