Followed instructions for VBA code. But, when I hit the button, it out puts 10,000 pages, not just the ID I'm working with. I put the button on a form that is opened from the main form.
To preview this same report i used: DoCmd.OpenReport "SAR non-litigation-Annuity Language-Minor" , acViewPreview, , "[ID]=" & [ID], and that works great.
How do I print this report to word and only get the report for the ID i'm working with?
Scott Axton 2 months ago
How are you printing it?
You should be able to just print fom the preview screen and only print he single report, Not all of them.
If that syntax is returning the correct report it shouldn't print additional pages.
Adam Schwanz 2 months ago
Just to verify, is there an ID field on the form you're pushing the button on?
If there is, you have spaces and dashes in the name, very possible access is trying to do some kind of mathematical calculation with it. Try putting it in brackets and see if it works. [SAR non-litigation-Annuity Language-Minor]
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.