Bez:

The LinkMasterFields and LinkChildFields properties are properties of the
subform *control*. This is the control in the parent form, Drawings, which
houses the subform, Revision Details. Open the Drawings form in design view
and then select the control which houses the Revision Details subform. In
its properties sheet you'll find the LinkMasterFields and LinkChildFields
properties on the Data tab. Set both of these to [Drawing Number].

Ken Sheridan
Stafford, England

bezzauk wrote:
Thank you,

Im not sure I am doing it correctly as It does not seem to work.
I have a field in the revision details record called 'Drawing Number'
I have a field in the drawings form called 'Drawing number'

The only place I can find the link child and master options is if I open the
revision details table in design view and go to the properties for the the
field 'Drawing Number'.

How do I then set these to the matching fields? Or am I completely barking up
the wrong tree!!

Thank you for your help,

Bez

Assuming you have a field in the Revision Details record that matches a field
in the record in the Drawings form, which you have to for this to work, in
Design View select the subform control (the control itself, not the form the
subform is based on) then goto Properties - Data and set the Link Child
Fields and Link Master Fields to the matching fields.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1