Can I set Access to Autofill Weekdays ?

[Ryno Bower]

Hello
Isit possible that If I enter data that one of the fields enters a weekday and if i enter the new next record that it would choose the next weekday?

E.g.

1. Monday | Post Office
2. Tuesday| Police Station
3. Wenesday...

From Monay to Friday, and repeat the who thing over again after each Friday.

Is this a challenge?

[NeoPa]

It's possible to do in a form.

In the AfterInsert() event procedure determine which weekday is required for the next record and set the .DefaultValue property of the control which manages that field to that.

[malcolmk]

Take a look here http://bytes.com/topic/access/answers/901669-day-week Simply place a popup calendar control yo select date for each entry or auto increment date and get dayname.