I have an electrical bill calculation form. In one field the consumed units are stored and then they are multiplied by 4 to give the amount due to the consumer. Now what if the rate of the electricity goes up and the unit is 5$. How will the user change the rate at his own discretion? Also if he changes the rate today from 4 to 5 , the previous records will also be modified at the new rate. How can the user change the value for today , without modifying the previous records?
Speaking of records , when I open the form the label1 shows the caption of the first record as I have set its caption property to this.value :

commandbutton::click
thisform.label1.caption=(thisform.film1.value)
dodefault()

But when I click the Next Command Button , the value of the film1 text box changes but the label caption still shows the first record. But when I click it again , the label caption changes to the 2nd
Record value , but the record pointer has moved to the 3rd record. How can I simultaneously display the label caption with the film1 text box value?
Thanks To All
Zaraq Bari