Hi,
I've created a database to be able to add in new aircraft parts, edit parts and search and duplicate parts into a raw data set. There is currently around 12,000 rows of data in the raw data sheet with 10 column headings (e.g. Part Number, Section, Reference, Quantity). When a user comes to edit information in a part's row (most probably being the quantity) and makes the changes, i'd like there to be the function that when the row is double clicked (or if easier a cell at the end of the row named history), a form box appears with a list of the edit history and what has been done to the fields.
For example, a user changes the quantity of a 'Bolt' from 36 to 30 as they have removed 6 bolts. Then, when the row or end cell is double clicked, a from appears saying " 'Quantity' changed from 36 to 30 on 27/04/2016" and this history also shows changes to all other fields.
Is this possible? If so it would be great if someone could explain it to me, or link me to a video explanation.
I have very basic knowledge of VBA and how it works, so i'm not sure if i'm going to be throwing myself into the deep end here!
Cheers
Bookmarks