Another Synchornizing Subforms Q

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.

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 wrote:
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 (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
http://www.accessmonster.com/Uwe/For...forms/200803/1

Thank you this helped!

"ruralguy via AccessMonster.com" wrote:

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 wrote:
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 (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
http://www.accessmonster.com/Uwe/For...forms/200803/1