form keeps "calculating"

[qwkslvr1999]

I have a form that contains 2 subforms, 2 command buttons,an unbound text box and another text box , testid=[subform1].[Form]![datesid].

Subform1 is linked to Main Form by the unbound text box and subform2 is linked to main form by text box testid.

both subforms are in datasheet view. table1 and table2 has a 1 to many relationship.

This is how it works. I select/add a record in subform1 and the related record is pulled up/added in subform2. Works fine...

Here's the problem:
Everytime I update a record in subform2, the form keeps refreshing/calculating which brings the focus back to the first item in subform2. status bar shows "calculating". This is extremely hard because I have 52 fields to fill up in subform2.

When I test subform2 alone, my tab order is good and I do not encounter the problem.

What could I have done wrong?

Thanks!

 

[WayneRyan]

qwk,

Is it possible to use Access's Master-Child links for the subforms.
Access is more efficient at keeping your forms in "synch".

It sounds like you have some code in "AfterUpdate" events in
subform 2, that cause a Me.Requery. Hard to tell without seeing
the database.

Wayne