Greetings,

I would like to create a combobox that lists all of the dates in the current work week. I have a combobox on a time card form that lets the user select the work week and I would like it to be the critreia for a combobox the user can select the date from.

I figure I can use DatePart with the combobox as the criteria, but I can't figure out how to get the range of dates to filter from.

Any thoughts? Or am I making sense?

Thanks

Hi,
the first day of the current week is:

Date() - WeekDay(Date()) + 1

The last one is:

Date() - WeekDay(Date()) + 7

You should be able to figure out what the rest is based on these !
HTH
Good luck