subform to subform conditional post

[RANCHLAW56]

I have a form with several tabbed subforms. Several of the subforms are for gathering peoples names and information (lastname, firstname etc.) the forms are named for the persons role (reporting party, complainant, victim, etc.)

How can I post information entered into one subform if a check box is selected? (reporting party = complainant)

I am trying to eliminate repetitive entries but have to duplicate information across tables.

[RuralGuy]

If you have a "people" table then it could contain *all* of the people, complaintant, reporting party, victim, etc. Then a ComboBox could be used to select these "people" and the NotInList Event could be used to describe a new "person". Then only PeopleID's would be included in the "case" table.

[RANCHLAW56]

Have to use individual tables. I proposed the single file but the Boss overruled me and said they would be in individual tables.

[RuralGuy]

Hmm...I guess it is time to ask the boss for the solution then.
Two examples:
http://allenbrowne.com/AppHuman.html
http://allenbrowne.com/ser-06.html

[RANCHLAW56]

Each person can have multiple roles in the incident and the Boss wants to be able to click on the role tab and see the person in that role.

Reporting Party, Complainant, Victim, Witness, Suspect etc.

So it is either find a way to post to the other subform or reenter the data.

[RuralGuy]

Each tab can have its own SubForm with a different query into the *same* table.

[RANCHLAW56]

Same table is NOT an option.

I know this can be done but I cannot get the code right.

This is the code I have currently:

Private Sub ISCOMPLAINANT_DblClick(Cancel As Integer)
On Error GoTo Err_ISCOMPLAINANT_DblClick

Me.Parent.Complainant.Form.Race = Me.Race
Me.Parent.Complainant.Form.POB = Me.POB
Me.Parent.Complainant.Form.Occupation = Me.Occupation

Exit_ISCOMPLAINANT_DblClick:
Exit Sub
Err_ISCOMPLAINANT_DblClick:
MsgBox Err.Description
Resume Exit_ISCOMPLAINANT_DblClick

End Sub

Returns the following error:

Object doesn't support this property or method

Button is located on the Reporting Party subform and trying to post to the
Complainant subform.

[RuralGuy]

A SubFormControl does not always have the same name as the SubForm it displays. The syntax is Me.Parent.SubFormControlName.FORM.ControlOnSubFormName

[RANCHLAW56]

I think I may have wandered too far into the woods and now I'm lost.

I can send you a copy of the db if it will help us talk apples-apples.

[RuralGuy]

I'll PM you with my email addy. I have some time today.

[RuralGuy]

I've attached your db to an email. If it is too big for your ISP let me know and I'll use one of the file hosting sites instead.

[RuralGuy]

Post #8 was the solution. I've marked the thread as Solved.