Printing a report from form in view

[ItsMe]

The following should open the report to a single record that equals the field named SITE NUMBER, provided the field exists in the reports RecordSource. I left off acWindowNormal in case that was conflicting with your DB settings.



DoCmd.OpenReport "Front", acViewPreview, , "[SITE NUMBER] = " & Me![SITE NUMBER]

[keiath]

Hi

Yeah that kinda works you have to input the site code but that's fine, at least now it only opens the report I want

Thanks for your help in this matter

[ItsMe]

The code works. What kinda works is your report. The report's recordsource needs to be capable of managing the criteria you send to it.

[keiath]

Like i said it does work, I get a dialog box, I type in the Site code and it brings up the correct page

[ItsMe]

I can not know for certain but I have my suspissions.

You get a prompt similar to the one in this screenshot?
https://www.accessforums.net/queries...tml#post220366

[keiath]

Yes I am

Thank you

[ItsMe]

I made a fundamental error in the code I provided to you in post #16. I edited and it is correct now. Should be
DoCmd.OpenReport "Front", acViewPreview, , "[SITE NUMBER] = " & Me![SITE NUMBER]

Having Said that, the previous code should have worked. As long as your report can filter on SITE NUMBER the above code should work.

[keiath]

Yep after sorting out the report ALL works fine

Thanks

[ItsMe]

Glad you have it working and sorry for not taking the time necessary to verify the code I provided to you in post#16.

[keiath]

This is solved

Thanks