I'm currently building a database for claims handlers to input recovery and storage costs on claims.
Different handlers have different limits to which they can self authorise. If it goes over there limit they need to have an authority code.
I'm trying to get it so that the authority code field on the form is disabled unless the "recovery cost" field is higher than the "recovery limit" field I then need the "authority code" to be a required field. Anyone able to help apologies if this sort of thing has already been asked I did look but on a smart phone it's a pain and I often miss pages by accident due to my fat thumbs.
I must also add that I am really rusty on VB code
Different handlers have different limits to which they can self authorise. If it goes over there limit they need to have an authority code.
I'm trying to get it so that the authority code field on the form is disabled unless the "recovery cost" field is higher than the "recovery limit" field I then need the "authority code" to be a required field. Anyone able to help apologies if this sort of thing has already been asked I did look but on a smart phone it's a pain and I often miss pages by accident due to my fat thumbs.
I must also add that I am really rusty on VB code