Reference on subform from another

[Eric the Viking]

Dear All
Your help would be much appreciated once again.
I have two subforms on an unbound form.
Subform1 has a list of clients as a continuous form.
Subform2 has detail of each client and is set to invisible.
The forms are linked with a common child/parent field.
I am trying to get subform2 to become visible when I select a line on subform1.
I have tried various options in VBA for the got focus event of the form and for controls in subform1 but cant make subform2 become visible even thought the child/parent link between the two works fine to show the relevant data.
Any ideas?
Regards
Eric

 

[John Big Booty]

Check this link for the correct Syntax for referencing Forms/subforms and their controls from various relative locations.

 

[Eric the Viking]

Hi

I have this already but it only references a subform within a subform whereas what I am trying to do is find a way of referencing two subforms which both sit on a main form side by side.

or have I missed something on what you posted?

Cheers

Eric

 

[RainLover]

Eric

The Link does have the information you need. Go back and have another look.

 

[Eric the Viking]

Hi
Doh failure to engage brain - you are correct I missed something
Works great thank you both

Cheers

Eric