Hi. I have spotted another problem. When I select a new week and try and add new data it doesn't write the data to the work book.
Do I need to use the code you gave me in addition to the code I had already written for the save button?
I am guessing that your code just saves over the historical data that is already there?
What I am trying to acheive is:
The user can select a site and week. click view/amend and the form will be populated with that weeks data. The user can then amend the data and click on save and the data will overwrite the old data (this works fine).
the user also has to be able to add new data by slecting the site and week, filing in the form and clicking save or by selecting a week and site that has already been inputed, clicking view/amend to populate the form then changing the week drop down to the new week and clicking save.(this is so the user doesnt have to enter the data every week but can chose a historical week change the data if neccesary and copy it to the current week)
Hope that makes sense. Any help would be apreciated. Also if you could put some comment on the code so that I can get to grips with it that would be great. I intend to use the principles for a more complex form and would like to understand how it works.
Many thanks
Nods
code for the amend button
Code for the save button
Bookmarks