Positioning a subform when visible

[Eric the Viking]

Dear All

Not sure if there is a solution to this but here go's

I have two subforms on a main form linked by parent/child. The first subform is a table view listing records. The second subform is not visible until a control on the first subform is clicked whereupon it becomes visible showing greater detail for the record.

I would like the second subform to open to the right of the first and alongside the relevant record.

I have been messing around with a line of VBA:

Me.Parent!NAMESUBFORM2.Top=Me.CONTROLNAMEOFSUBFORM1.Top

which will position it at the top but trying various things and options to try and dynamically position subform 2 has been to no avail.....

Have searched far and wide on web and not found a satisfactory solution.

Does anyone know of a way?

Cheers

Eric

 

[Isskint]

Have a look at the SelTop property.