View Full Version : Report on Form Results


Sparky
12-19-2001, 06:24 AM
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
12-19-2001, 06:28 AM
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. http://www.access-programmers.co.uk/ubb/smile.gif

Sparky
12-20-2001, 01:38 AM
Excellent,works a treat!!!

Many thanks once again for your help/guidance.

Merry Christmas