hi all can you help please , I have a subform with two fields [weld standard] and one [weld code] every time the subform changes i.e number of rowes I want to be able to look at value in [weld standard] and depending on value change the value in [weld code] for each row , I have tried this code
If Me.Welding_code.Value = "IX" Then
Me.weld_code.Value = 2
and put it on the after update of the [weld standard]and works ok but I need it to look at each row , look at each [weld standard] and change [weld code] value .
ant ideas please
If Me.Welding_code.Value = "IX" Then
Me.weld_code.Value = 2
and put it on the after update of the [weld standard]and works ok but I need it to look at each row , look at each [weld standard] and change [weld code] value .
ant ideas please