synchronizing records in a multi layer subform

  • Thread starter Thread starter CBeavers
  • Start date Start date
C

CBeavers

I have a multi layer subform. I want the main form to control what record is
displayed. As long as my cursor is in the main form field, the subforms move
correctly. I want to be able to add and edit in the subforms.

My problem is that if my cursor is in one of the multi-layer subforms, the
record in the subform will move but not the record in the main form.
 
Subform records are the many side of a one to many relationship, and as
such, there should be no reason for the main form to move based upon any
change in a subform. Either you need to correct your design, or it is
possible that the main form is unbound. In which case you need to write code
to cause the main form to move to a new record.
 
I have a parent child relationship set with the Parent Form to all the
subforms.

Is there an OnCurrent event code I could write? What would it be?
 
Back
Top