"Week of" drop down menu which automatically populates date values

[mgarret]

Hi all—

I am very new to ACCESS (like very new) so any help is greatly appreciated.

I am trying to create a form which selects a “Week of ” date value and then populates 7 boxes with the dates in that week.
1. So I need a drop down menu for the “name”
2. The one which selects the “week of”
3. The “date” field then automatically populates with the “dates” in that week.

Name	Week of	Day	Date	Scheduled	Kept
		Monday
		Tuesday
		Wednesday
		Thursday
		Friday
		Saturday

Name	Week of	Day	Date	Scheduled	Kept
Joe Smith	April 1, 2013	Monday	April 1, 2013	7	8
		Tuesday	April 2, 2013	9	7
		Wednesday	April 3, 2013	6	5
		Thursday	April 4, 2013	No Sessions	No Sessions
		Friday	April 5, 2013	8	3
		Saturday	April 6, 2013	No Sessions	No Sessions

Any assistance is greatly appreciated. Thanks so much!!!!!

[June7]

This is easily done with calculations in textboxes. However, if you want to save 7 (although you show only 6 days) records that is complicated.

[mgarret]

Hi. Thanks. Yes, I need to save 7 records