Is there a way to have print/save options for filtered form without utilizing right click? (2 Viewers)

[stormwaterguru]

From what I have gathered, I can't simply bypass by putting a command button with macro to export a report AND have criteria (from a Form). It will export all report records...I believe. I was having a hard time wording the concept I am looking for- my apologies if it's still not clear.

How it works now is you are viewing a Project (form) and you can use a command button to view the Report (project specific permit) in Print Preview. The only option I see to save as or print is right click. My toolbar doesn't show the print options like I've seen in videos. Is there any other method to do this? Even a separate floating form that has print or save buttons? Anything? I don't feel like it's intuitive to outside users.

I thought I was being clever by creating a blank form that merely retained the ProjectID and had the Report (permit) in the detail section of the form, linked by PK & FK. Added two buttons there to download and print, but I couldn't figure out if there was a way to print Report being currently viewed on the Form. I am assuming I was attempting to create a poor or non-functional workaround. Thought I'd try at least!

 

[Gasman]

You use the form data as criteria for the OpenReport command in the Where clause.

 

[stormwaterguru]

You use the form data as criteria for the OpenReport command in the Where clause.

That's my current process unless I am misunderstanding! It opens to needed report, but I was hoping to bypass opening report to "print preview" to then downloading/printing. I am hoping to download or print with a single button click of the correct filtered form.

 

[tvanstiphout]

Maybe I'm missing something, but DoCmd.OpenReport ..., acViewNormal can print to the default printer right away.
And DoCmd.OutputTo can "download" (we say: export) the report.

 

[CJ_London]

I don’t like to guess what the problem is without seeing what code you are actually using

 

[stormwaterguru]

I don’t like to guess what the problem is without seeing what code you are actually using

I was using macro not VBA, my apologies.

 

[CJ_London]

I don’t use macros due to their limitations so I’ll drop off this thread