Copying string values between the same field in succeeding row?

In a subform, how do I copy string values between the same field in succeeding row?

Sound simple but has me stumped...help

thanks

Larry