entering data in form 1 to go to form 2

  • Thread starter Thread starter Ray
  • Start date Start date
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

The Easy Day
 
i'm entering data in form 1 text box 1 and i want it to
show up in form 2 in text box 2

You're mistaken.

You are not entering data into Form1.

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.
 
Back
Top