Selecting Row On Sub Form(Cont Form) to select record on Main Form

[MoleY]

Good Morning guys and Gals,
Would someone be able to help me with my problem?
How do I go about selecting a record on a subform to then show the record on the main form? I've had a look through the forums, but i've not seen anything that would help me (that i know of!)
I've attached a jpeg to show what i mean.

Any help would be very much appreciated.
Cheers
Stuart

 

[JANR]

here is a webpage which deals with refrences to formcontrols: http://www.mvps.org/access/forms/frm0031.htm

I belive you are looking for Me!Parent syntax

JR

 

[MoleY]

Thank You for that link,
As the form is a 2nd subform i used the following
Me.Parent.Parent!ControlName which for me would mean Me.Drawings_qry.Drawings![Drawing Number] and applied it to a ondoubleclick. But then it says method or datamember not found, do i not need to tell it to change to the record selected?

I know i probably being really stupid here, but i'm a novice at best when it comes to things like this!
Cheers