Access Sequential Dates

Question

I am trying to get access to auto date an order entry. So 1/1/14 is a Monday and they are selling someone hot dog that day. 1/2/14 is Tuesday and they are selling them one Hamburger. Each day of the week is always assigned a specific food. People submit preorders and we have to enter the data into the database before it is served. I have a subtable for each order content and when adding them I want Access to automatically put the next date so I don't have to type in the 1/1/14, 1/2/14, etc.

Also it would be great if access automatically did not use weekend dates.

I am not able to code at all, and could not find any information on this so it might not even be possible.

Thanks in advance!

Answer 1

[Food per Order.Serve Date]  does not sound like a control name to me.  You should use the name of whatever control is bound to the Serve Date column.

Answer 2

If this is in a Form module, what is Food per Order and what is Serve Date?