Reputation: 5796
I just migrated to ms access 2007 and created my own ribbon. In my form, I have this "print" button where if you click that it will open the "report form"
here is what I wrote in my VBA code:
Case "btnPrintRevisionEingabe"
DoCmd.OpenReport acReport, "Revision_Eingabe_rpt", acSaveNo
and when I clicked on the "print" button
I'm getting an error "type mismatch runtime error 13"....
Please help.. Thanks
Upvotes: 0
Views: 808
Reputation: 166606
Try just the following
docmd.OpenReport "Revision_Eingabe_rpt", acViewReport
nothing after that. Leave out the acSaveNo. That should work.
Upvotes: 3