I know that a form is not suppose to be used for printing and rather have a report created to do the work for printing. However all of the users choices are done on the report and their is no good way I can think of to pass the control data from the form to a report without having to recreate the whole form in reporting.
My issue is that no matter what DoCmd.Printout I use I am getting one of two errors.
1. "The PrintOut Action was Cancelled"
2. Index or key field can not be null. (this is because I do not want the end user to save the data back to the tables and have turned off saving the form.
Any thoughts on how to get around this or another command I could use to get the form and my charts on the form to print?