Hi,
I'm wondering how to change field value depending on another fields falue.
Within one form a have for example: service ID which is a contains a string that should be a combination of strings from two seperate fields: customer ID and service type. So, if my customer AAA has service BB, then in this case service ID should be AAABB.
User should be able to type service ID by hisself but I want to have it changed due to service type change (when user changes service type from BB to CC, then service ID should be AAACC).
Do you guys know how to do it with Virtual Basic code? Should I know some kind of a function as ServiceType "after update event" that allowes me getting char from a string based on it's index?
Some kind of a line: Me.ServiceID.Value(4) = "C" and Me.ServiceID.Value(5)="C" ? Thanks in advance! : )