Text Box default value in a continuous form

[Mike]

I have a continuous form with two text boxes in each row.
The default value of TextBox2 is "=[TextBox1]".

_____________________________________________

[TextBox1] [TextBox2]

_____________________________________________

But when I open the form, TextBox2 in each row is filled
with value of TextBox1 in first row (i.e. from the first
record on the form).
What do I need to do to make the TextBox2 take the value
from its own row?

 

[MacDermott]

You could start by putting
=[TextBox1]
in the ControlSource instead of the DefaultValue property.

Of course this won't let you edit it, and there's probably little value in
displaying the same value twice.

Perhaps you could explain a bit more about what you're trying to accomplish.

HTH
- Turtle