Another Synchornizing Subforms Q

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

simplymidori - 01 Mar 2008 06:00 GMT

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.

Reply to this Message

ruralguy - 01 Mar 2008 19:00 GMT

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.

>Okay I have a main form with 2 continous subforms.
>
[quoted text clipped - 7 lines]
>I'm still struggling with the check box and linking the master/child fields.
> Is this possible? Any suggestions.

Signature

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

Reply to this Message

simplymidori - 01 Mar 2008 22:22 GMT

Thank you this helped!

> Create an invisible (visible for testing) TextBox on the MainForm. Set the
> ControlSource to SubFormControl1Name.FORM.IDControlOnThisForm
[quoted text clipped - 16 lines]
> >I'm still struggling with the check box and linking the master/child fields.
> > Is this possible? Any suggestions.

Reply to this Message