Another Synchornizing Subforms Q


S

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.
 
Ad

Advertisements

R

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.
 
Ad

Advertisements

S

simplymidori

Thank you this helped!

ruralguy via AccessMonster.com said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top