Another Synchornizing Subforms Q

[simplymidori]

Okay I have a main form with 2 continous subforms.

Subform1 - sbfmClientSearch with a wildcard search by client field.

I type "Toy" I get every client that contains this text. I placed a check
box so I can select the exact client I want to see details in Subform2.

Subform2 - sbfmCustDetail

I'm still struggling with the check box and linking the master/child fields.
Is this possible? Any suggestions.

 

[ruralguy via AccessMonster.com]

Create an invisible (visible for testing) TextBox on the MainForm. Set the
ControlSource to SubFormControl1Name.FORM.IDControlOnThisForm
The ID should be available in the SubForm2 as well.
Now Set the LinkMasterField of SubFormControl2 to point to this invisible
TextBox and the LinkChildField to point to the correct field in that SubForm.

No CheckBox needed! Just clicking on a record in SubForm2 will change the
CurrentRecord of that SubForm and the ID field as well.

 

[simplymidori]

Thank you this helped!

Create an invisible (visible for testing) TextBox on the MainForm. Set the
ControlSource to SubFormControl1Name.FORM.IDControlOnThisForm
The ID should be available in the SubForm2 as well.
Now Set the LinkMasterField of SubFormControl2 to point to this invisible
TextBox and the LinkChildField to point to the correct field in that SubForm.

No CheckBox needed! Just clicking on a record in SubForm2 will change the
CurrentRecord of that SubForm and the ID field as well.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com