>I have try the codes by I got a error msg > >numinstal = this.value >for i=1 to numinstal >lcFieldName = "d_date" + alltrim(str(i)) >replace &lcFieldName with {day(date_commence)/((month(date_commence) + i)/year(date_commence)} >endfor > >I got this msg : Variable d_date1 not found > >Why is it so? I have three table inside the data environment, "customer", "bike" and "instal". > >And d_date1 is a record in bike. There are d_date1 to d_date48. I wish to have a way to auto replace the data from d_date1 to d_date48 depending the months enter by the user (in textbox field "text4") with increament of one month. > >I have placed the above codes inside the "valid" procedure of (text4), and I got the error msg "Variable d_date1 not found". Just to cover all basis, have you put a SELECT bike before the code? Also ... a side note. Have you tried to think of a way to normalize your data?