Macro - closing a form

M

murfitUK

I've created a macro that opens a form, copies some records and then closes
the form.

When the form closes I get the message "You have copied a large amount of
information...do you want to save this info?"

I would like the macro to answer this "Yes" as I need to paste this
information into a Word doc.

Can anyone let me know how the macro can answer "Yes" to this message box?

Thanks.
 
Top