Parent and child form

[Carrie]

Hi

I'm currently setting up a form which has a main form and two subforms.

At first I could get it all to work and scyncronise fine. I then decided to help make data entry easier by breaking down the two subforms into tabbed controls.

i.e. The first subform is split into three forms. Placement form, location form, store form (all come from the same table so the primary key is the same for all). Depending on what the client chooses in the main form depends on which one of these forms appear. My second subform is then split into two forms Legs and Non Leg (all come from the same table so the PK is the same again). Again depending on what is specified in the main form depends on which of these forms appear.

My problem is trying to get these two tabbed control subforms to syncronise.

I can only get the placement form from the first subform to scynchronise with the Leg and Non Leg. I obviously also need to get the location and store form to scyncronise with the leg and Non Leg subform

Is this possible. I can't seem to find anything on the forum and none of my attempts are working!

Any help would be much appreciated !

Carrie

 

[Peter D]

There should be "Link Child Fields", and "Link Master Fields" properties for your subform control. These should match up the key fields on your master and child forms.

If the user is changing control values, and you want the appropriate subforms to appear/disappear, or requery, then use the statement

Forms!MyFormName.requery

or

Me.requery

...(substitute "MyFormName" for the name of your form) from the AfterUpdate event procedure of the control that the user changes.

Hope this helps,