Inserting a chart from VBA

[Peter Hill]

Is it possible?

I want to create a new form and insert a new chart control on the form:
eg. If I wanted to insert an Image on to a new form I would write:

Dim frm as Form
Dim ctl as Control

set frm = CreateForm ()
set ctl = CreateControl(frm.name,,,dimensions etc)
frm.controls(ctl.name).Picture = "Picture.jpg"

....

But - How do I add a new chart control?

Regards,
Peter Hill

 

[MacDermott]

Although it's possible in VBA, creating new forms programmatically in Access
is usually not the optimum approach.
OTOH, it's quite possible (and not uncommon) to create a "skeleton" form
manually, and customize it programmatically.