vba - Replacing Text In a Textbox in Continues Forum -

it's simple enough change textbox value of form. how change text box of continues forum on every record?

the onload event not work because change first record only. ideas?

example code:

private sub form_load()     txb_name.value = txb_name.value & "test" end sub

in example, continues form this:

 text1test  text2  text3  text4  text5  text6

notice how changed first record.

what need this:

 text1test  text2test  text3test  text4test  text5test  text6test

found solution using calling own function in recordsource:

=myfunction(fieldname)

and then, can put whatever want in function

function myfunction(fieldnameas string)     myfunction= fieldname& "test" end function

this loop on records instead of first one.

Sharma