i have a table with a date field in it, set as short date, and a field for a NAME
then i have a form with a command button to change the date for a new date which is the beginning of the next week.
i used the following code:
dim TodayDate As Date
dim StrSql as String
TodayDate = Format((Date -...