Copy Form Charts and Paste into Powerpoint Slide

[vishal8723]

I am developing a application in ms access, that will copy "Form Charts" and paste into powerpoint. I am using VBA code to insert records in a Temp Table, which is binded to Form Chart by select query. Now when I run the code the form does not load the charts completely and the copy command does not copy the chart, as the form did not load the charts properly. The code runs into the next command or the loop and then starts inserting the temp table for the next time. My code to copy is as follows : -

DoCmd.OpenForm "MainChart_Form", acNormal

Forms!MainChart_Form.Charts_form.SetFocus

DoCmd.RunCommand acCmdCopy

DoCmd.Close acForm, "MainChart_Form"


Please suggest, how can I delay the program, so that the Form Loads completely with the Charts and then use a copy command and them paste into ppt OR you could suggest some other way.

Note : I have to copy and paste approx 100 charts.