Hi Ray,
Assuming that both Form1 and Form2 are using the same
table and that text1 and text2 are bound to the same
field, you should be able to pick up any change made in
field from text1 by requerying form 2 assuming that both
forms are open at the same time. On the afterupdate event
of text1 you could put Forms!form2.requery
You are using Form1 AS A TOOL to enter data into some Table. Forms
don't contain data, any more than my office window contains the Idaho
Treasure Valley and the Owyhee Mountains.
If you have Form1 and Form2 both based on the same Table, then the
data will show up on Form2 after it has been entered using Form1. If
both forms are open, you might need to requery Form2.