Here is my situation. Attached is my Database with a Input Form which provides data that is to be printed via report but that form is not bound to any table or query. I just takes input from form fields as this is not required to be saved later. I want to use this form to generate the loan repayment schedule and want to print it.
I hope this would clear my situation what I want to print via report from this form as I don't feel I need to save the schedule when it can easily be generated any time using standard access fundtions and with just 1 or 2 parameter values.
AS I suggested in my last reply, if you do not use data from the DB and you are not saving the calculations in the DB, why not use a spreadsheet. You can format spreadsheets easier and better that an Access report !!??
If you insist on generating schedule type report in access then I would suggest you create a temporary table and use action queries to append the data generated, print the report (based on the temporary table) and then delete the table.
If I did that, I would create an permanent empty 'schedule' table in the DB, populate it with the data and then just delete all the data afterwards.
There is probably a more elegant way (if so would someone give us a clue) but it is one way.