synchronizing records in a multi layer subform

[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.

 

[Arvin Meyer [MVP]]

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.

 

[CBeavers]

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?

 

[Arvin Meyer [MVP]]

If there is a relationship to a textbox between subforms, that you are
trying to sync up, there are several ways to do it. Look at the Customer
Orders form and subforms in the Northwind sample database that comes with
Access for a demonstration.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com