Report from open form

[e51lrrp]

Finally light bulb moment....found on line the different AcView Enumeration. Understand when I used 'acViewNormal' that is PRINT.....THANKS
s

[pbaldy]

Happy to help Sharon!

[e51lrrp]

Paul...I have, hopefully, just have one more obstacle for the development of my program and that is totaling and order. I have read and attempted several of the suggestions in my book and online but none seem to work for my application. I want to get a total for an OrderID. In other words a person could order many ItemID's and I want that order summarize. So somewhere I need to tell access to sum up the ItemTotals for any given OrderID. Any suggestions?
Happy Holidays to you where every you are...Sharon

[pbaldy]

Typically in a group or report footer textbox:

=Sum(FieldName)