Modify All Records

[mapat]

Hello,

I have a form (linked to a table). I have 'txtBoxA' and 'txtBoxB'. Now, each record will have different values in 'txtBoxA' and based on that value 'txtBoxB' will change for that specific record. In the 'OnLoad' event for the form I type the code, but when I re-open the form it only works for the 1st record, and it doesn't change all the rest (records).
Do I need a loop to go through all the records?? I thought that this was done automatically by ACCESS. If I have to use a loop, can anyone please give me the exact syntax?

Please, this is really urgent so I would really appreciate an answer asap
Thank you very much.

 

[RuralGuy]

Use the Current event of the form instead of the OnLoad event.

 

[RuralGuy]

Why would you want to have a field in your table whos value can be derived from another field in the table? It is an unnecessary field!