Hello- I'm trying to open a report from a button on a form in preview mode. When the report opens, the option to close print preview, pdf or xps, etc on the top nativiation pane is locked not allowing me to export to a PDF, change orientation, or print. I have to go to Window and then select it to bring focus to the options. Here's my code I am using:
DoCmd.SetWarnings False
DoCmd.OpenQuery "UpdateMasterInvoice", acViewNormal, acEdit
DoCmd.Close acQuery, "UpdateMasterInvoice"
DoCmd.OpenReport "Invoice", acViewPreview, , strWhere, acWindowNormal, strOpenArgs
DoCmd.Close acMacro, "InvoiceExport"
Any suggestions?
Thanks:
Anissa :banghead:
DoCmd.SetWarnings False
DoCmd.OpenQuery "UpdateMasterInvoice", acViewNormal, acEdit
DoCmd.Close acQuery, "UpdateMasterInvoice"
DoCmd.OpenReport "Invoice", acViewPreview, , strWhere, acWindowNormal, strOpenArgs
DoCmd.Close acMacro, "InvoiceExport"
Any suggestions?
Thanks:
Anissa :banghead: