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?