leprince2007, we will get you through this, but there a few things you should know about MVD and a few things we need to understand about your project. First, in the normal and elementary progression of MVD you would have a form with a tablegrid of your database records. This is what CDB was alluding to. For the sake of discussion we will call it Form1, but it can be any name you want. Then you would have a subsequent form to be able to add records and change records. We will call this Form2, but it can be any name you want.This form needs to know if it is in ShowRecord mode or NewRecord mode. Typically you would have a new button on the tablegrid form (Form1) which would open Form2 to enter a new record. MVD puts Form2 in NewRecord mode. Also in Form1 you would have buttons to edit and/or delete records in the tablegrid of database records. The edit button would open Form2 to change the record info. MVD puts Form2 in ShowRecord mode.This is the process in its elementary state. This is not an absolute way you have to do it, but it will require a little bit of scripting, which is not a big deal.
Question 1 - In your VB project did you have a tablegrid form to navigate to the update form you presented in your project in your post. If not, that's ok. We can still work with it.
Question 2 - If you did not have a tablegrid form and only used the one form to do all your adding and updating, then how did you retrieve the record you wanted? Did you use the date field at the top of the form to search for the corresponding date record?
Question 3 - What is the purpose of storing all your daily records? Is it to only retrieve the last date a task was performed? If that's the case, then eventually (after each task has been performed twice) you will have dead records in the database and will have no value to the application and wasting space.
Question 4 - If there is another reason for storing past records, then when you select a record , say a record from 6 months ago, what should show in each of the respective task date label displayed on the form. Is it the last date prior to the date displayed at the top? I'm not exactly sure what benefit this would have in your application to know this, but it's your app and it that's the way you want it, then so be it.
Let's start with these questions and see what we can do. Now having said that, I cannot guarantee you my time commitment to this. This is not my full time job, but I will try to help as much as I can. If Derek or CDB or anybody else would like to step in at any time, by all means do so.