I'm in the process of designing an Access database for a reservation system. I have a Java front end that allows data entry into the database, but would like to have a confirmation report printed each time a new record is added. I know that one of the options when creating macros in Access is to print a report, but I'm not sure what condition to use so that the macro is run every time a new record is added. Also, I want the report to use the most recent information in the report. Any help would be great.