I am trying to validate an 'order completion date' against the last 'delivered date' of the items in the order. The users often manually enter an 'order completion date' which is less than the 'delivered date' of an item on the order which means that the order is 'complete' before all of the items are delivered, which is wrong.
There is an 'orders' page and an 'items' page. I have written a SQL stored procedure which gets the MAX(delivery date) from the items page and posts it to a GridView on the 'orders' page, but not into the form into which the users enter the 'order completion date'.
How can I compare the GridView 'delivered date' and the FormView 'order completion date' on ItemUpdating (vba) to make sure the 'order completion date' is equal to or after the MAX(delivery date)?
View Complete Post