Report on Form Results

[Sparky]

I am not sure if this is possible but I would like to produce a report depending on the results of a form.

Any help would be most appeciated.

Many thanks

 

[mrssevans]

Yes this is very possible. Make a button to preview your report and then in the code use something like this.
DoCmd.OpenReport stDocName, acPreview, , "[OrderID] = Forms![Customer FRM]![F&I Orders FRM].form![OrderID]"

This will filter for what you want to see. Hope this helps.

 

[Sparky]

Excellent,works a treat!!!

Many thanks once again for your help/guidance.

Merry Christmas