0
votes

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

1
hmmm why is that? i don't understand...tintincutes
i accepted the answer from astander...tintincutes

1 Answers

3
votes

Try just the following

docmd.OpenReport "Revision_Eingabe_rpt", acViewReport

nothing after that. Leave out the acSaveNo. That should work.