I have been trying to create a macro to update a colum for sometime now but i wont work :(
Here is what i want to do.
i have a field call Deliverystatus with two choice "Not delivered" and "delivered"
I have another field call Delivered date
I want to create a macro so that when someone change Deliverytstatus to "delivered"
The Delivered Date gets populate but the todays date.
Please some point me into right direction :D
Thanks in advance