Option box for choosing attendance input date

[timgeitz]

I would like to design a drop down option box on a form which gives me several choices for putting in an attendance date to record church attendance. Typically, a church secretary would record a member's attendance sometime after the date of attendance (eg. Monday or Tuesday after the Sunday's attendance). On my attendance form, I need to have an option box that would put in last Sunday's attendance date even though it's now Monday or Tuesday or even later in the week. That date would then be stored in the attendance table for attendance reports. Any suggestions on how to design such an option box?

I am using Windows XP with Access 2003.

Thanks for any help you can give,
Tim

[VALIS]

I would like to design a drop down option box on a form which gives me several choices for putting in an attendance date to record church attendance. Typically, a church secretary would record a member's attendance sometime after the date of attendance (eg. Monday or Tuesday after the Sunday's attendance). On my attendance form, I need to have an option box that would put in last Sunday's attendance date even though it's now Monday or Tuesday or even later in the week. That date would then be stored in the attendance table for attendance reports. Any suggestions on how to design such an option box?

I am using Windows XP with Access 2003.

Thanks for any help you can give,
Tim

Try typing the following formula in the control source
=Now()-Weekday(Now(),1)-2
This should give you last Sundays date.

[NeoPa]

You could try creating a TextBox on your form with a 'Default Value' of the previous Sunday and a 'Validation Rule' of must be a Sunday.

Set 'Default Value' to Date()+1-Weekday(Date())
Set 'Validation Rule' to Weekday([FieldName])=1

The operator can change it on the rare occurrence that it is for an earlier Sunday.
Don't forget to enter a value in the 'Validation Text' property.