I have a form with two subforms on it. The main form has a one to many relationship with each of the tables in the subforms. If I change the data in a field in one subform, I want it to go to a new record in the other subform and enter some data based on the first subform. I can change the data in the second form, but I can't get it to go to a new record. Here's the code I have to change the data in the second form:

Forms![MainForm]![SubForm2]!SubForm2FIELD= Forms![MainForm]![SubForm1]![SubForm1FIELD].Column(2)

How do I get the first subform to make the second subform move to a new record?

Thanks!

try onchange in subform1 use code to
setfocus to the second form.
doCmd ,, acnext(ornew)
i used this to move around in a subform but Im not sure if its what you want to do..

Thanks!