View Single Post
  #3  
Old May 4th, 2010, 03:22 PM posted to microsoft.public.access.gettingstarted
bezzauk
external usenet poster
 
Posts: 2
Default Linking a subform to current record

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

Linq Adams wrote:
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.