automatic dates

[maintt]

i want to use dateadd to have 24 dates added to a start date, this i have done, and on the form it looks ok, but when a student is absent for the date, i want to change the date when the student is absent and i want the remaining dates to recalculate, the first time a student didn't turn in i could not do this on the form, i am a novice and trying my best but this problem i can't seem to get my head around

maintt

 

[PNGBill]

If your Text Box Controls are Unbound then have box2date add from box1 and box 3 date add from box2 and so on.

This way, should you enter a value in box 6 then boxes 7 onwards should show an new date. May need to Refresh.

Also, May need to have an On Enter event that removes the DateAdd expression from the Data property of the control when you click on it. or something similar to that.