Count function for Date within subform
I have a time sheet application that I have made, and I need a little help with the final feature I would like to add.
See the attached image before reading, in order to give you a better understanding as to my need.
On the load of the parent form, 7 rows load on the subform (one for each day of the week). Currently when the parent form loads, each row in the "Day of the week" field is labeled with the respective day of the week (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
What I want to do is have the Date of the respective day be shown in the "Date" field. I need the "Date" field to reference the "Week Of" field (on the parent form) and do a count function to +1 day from the previous row. The "Week of" field will only allow the user to select a Monday, so it will always be shown as Monday - Sunday
See the attached image before reading, in order to give you a better understanding as to my need.
On the load of the parent form, 7 rows load on the subform (one for each day of the week). Currently when the parent form loads, each row in the "Day of the week" field is labeled with the respective day of the week (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
What I want to do is have the Date of the respective day be shown in the "Date" field. I need the "Date" field to reference the "Week Of" field (on the parent form) and do a count function to +1 day from the previous row. The "Week of" field will only allow the user to select a Monday, so it will always be shown as Monday - Sunday
For example:
If Week of = 10/22/2012 than
Monday = 10/22/2012
Tuesday = 10/23/2012
Wednesday = 10/24/2012
Monday = 10/22/2012
Tuesday = 10/23/2012
Wednesday = 10/24/2012
Thursday = 10/25/2012
Friday = 10/26/2012
Saturday = 10/27/2012
Sunday = 10/27/2012
Thank you in advance for all your help.