How do I run a Macro in Access 2007 each time a new record is added to the database
Posted on 2009-05-15
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.