I want to maintain Creation and Update dates at a record level. I have in the past used the before event but have experienced some issues with this method - that is updated Update date when no change has taken place.
To that end I was thinking of using the Data Macro - before change event to control this. I have tested on a simple Front End form with subform that links to to a backend with the two tables that have the data macro. It works just fine.
However, has anyone successfully tested Data Macros in a Access 2010 Runtime environment and are there any tips or tricks to making it work?