Hi all, I have a dilemma, my database contains vehicles and servicing etc, one area is movement of those vehicles being placed on different sites etc. At the moment the status of each vehicle is done manually, but I would like it done automatically.
For example when a vehicle is on a job a form is used to transfer it to that job with a onhiredate and when it returns a offhiredate, the status is active/on hire when it's on a job and idle/available when it returns, I would like the status of that vehicle to change on closing the transfer form, to change depending on the offhiredate but only effect that vehicle.
So if offhiredate is empty the vehicle is active/onhire and so on, but only effects the current vehicle, the vehicle ID is present in the transfer form. I have been trying with IIf statements but fail to know how to affect the update of status using the vehicle id as a reference.
Thanks in advance for your help.