I'm trying to find a way to use a date (input from form) to update the date records in a table. Using the start date provided by the user, the date records in the table should be updated in sequence but the first date for SunWk1 would equal the user provided date. The order of the records is important; it is for a menu that is 28 days long and starts with SunWk1 through SatWk4. I've tinkered with a loop but can't figure out how to have each date correspond to the order of the menu days. I read that I should use a query to order the menu days but these are static (meaning they will not be changed) and can't figure out how a query will sort the fields. I've attached the form and table that are affected. Thank you in advance for any help!