Access 2010
I have a macro that opens a table, clears the data and invites the user to paste in new data. The user then closes this table and clicks on a second macro from the ribbon to update this data to various locations.
What I would like to be able to do is have the user click on the first macro to open and clear the table, input the data and then on closing the table the second macro runs automatically.
Any help on this would be very appreciated as my current searches on the web have proved fruitless.
Many thanks
Chris
I have a macro that opens a table, clears the data and invites the user to paste in new data. The user then closes this table and clicks on a second macro from the ribbon to update this data to various locations.
What I would like to be able to do is have the user click on the first macro to open and clear the table, input the data and then on closing the table the second macro runs automatically.
Any help on this would be very appreciated as my current searches on the web have proved fruitless.
Many thanks
Chris