Macro to close report & clse the form

access2010

Registered User.
Local time
Today, 15:13
Joined
Dec 26, 2009
Messages
1,115
Hello, I am using MS Access 2003
.
I would like to open the form = VendorPayables_Maintenance_F
Choose a cheque number
Print the cheque
.
Can I have assistance in how to create a macro to
close the open report = d_One cheque information
and close the open form = VendorPayables_Maintenance_F
.
Thank you for your assistance
.
Roz
 

Attachments

Hello,

Why don't you use the AcViewNormal argument in place of AcViewPreview and then Close your form VendorPayables_Maintenance_F in this procedure.
I add a button for this in your form.

If a preview of the report is necessary, you can add an action
Code:
Docmd.close acForm, "VendorPayables_Maintenance_F"
at a close event of your report.

Have a good continuation
 

Attachments

Thank you for your suggestion which works.
.
Roz
 

Users who are viewing this thread

Back
Top Bottom