sherlc29:
We can’t' actually do the project for you nor could we even if we wanted to from the very general information you've provided.
The steps involved would be to have the on current event note the current record.
Then, potentially, the before and after update events would need to be called to determine if the change(s) were actually made.
Once all this is done, your button could be made available. Depending on a dozen different things would determine how the code would be written as you note Excel in your title, there will need to be a query written that handles part of this transaction.
So, as you can see, simply not enough detail provided.
You might find the following links to be helpful as to learning the fundamentals behind the DB and VBA that run Access.
MS Access 2010 Tutorials Access Basics - By Crystal > Database Normalization and Table Structures.
---
1
