Access Validation Check
Posted on 2011-05-12
I have a form called [Order Entry Control]. One of the fields on this form is the [DeliveryDate] which is pulled from the contract.
I have another form called [Order Form]. One of the fields on this form is called [OrderDate] and this field defaults to the [DeliveryDate]. Another field [CheckLate] is a check box, which the user selects if the order is past the [DeliveryDate]. Both of these can be modified by the user, but if the [OrderDate] is different than the [DeliveryDate] than the [CheckLate] box must be -1.
Both of these forms are open at the same time. The spaces in the form names are correct and I know it is bad naming practice but I am picking up the ball from someone else.
I want to do a afterupdate VBA on [OrderDate] that checks to see if the user has changed the date [so check to see if [DeliveryDate]<>[OrderDate). If they don't equal I want to ask user, "Is this a late order?" If yes then I want to check the [CheckLate] box in the VBA script. If no I want to tell user "Order date can only be changed for Late Orders" and then undo their date change.
I have researched and I just can't figure it out! Way to complex for my level