Access Validation Check
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
I have researched and I just can't figure it out! Way to complex for my level
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
I have researched and I just can't figure it out! Way to complex for my level
Hamed Nasr
We need a sample database demonstrating the issue with enough records to get the results. Supply the instructions to process the record and the expected output.
If the order date is set to a value later than the delivery date, is it still possible for it NOT to be a Late order?
If it must be a late order then I don't see the value of asking the user the question. Just set the checkbox.
It seems to me though that you would also need to unset the checkbox if the order date was found to be same as the delivery date.
If it must be a late order then I don't see the value of asking the user the question. Just set the checkbox.
It seems to me though that you would also need to unset the checkbox if the order date was found to be same as the delivery date.
ASKER
Peter57r,
You logic makes sense. How do I make a validation statement that compares two dates on separate forms to see if they are equal? If they match is runs a set value macro to make sure late box is unchecked. if false it runs a set value macro to check the box?
Form one value is [Order Entry Control].[DelieveryDate]
Form two value is [Order Form].[OrderDate]
Macro if true [checkboxtrue]
macro if false [checkboxfalse]
You logic makes sense. How do I make a validation statement that compares two dates on separate forms to see if they are equal? If they match is runs a set value macro to make sure late box is unchecked. if false it runs a set value macro to check the box?
Form one value is [Order Entry Control].[DelieveryDate]
Form two value is [Order Form].[OrderDate]
Macro if true [checkboxtrue]
macro if false [checkboxfalse]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Peter57r
Thanks for educating me on the terminology. The code wasn't as complicated as I thought it would be.
You did a great job explaining the steps to set it up also. I will have to keep your name in mind for future questions.
You seem like you would be good teacher.
Thanks for educating me on the terminology. The code wasn't as complicated as I thought it would be.
You did a great job explaining the steps to set it up also. I will have to keep your name in mind for future questions.
You seem like you would be good teacher.