A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking a subform to current record



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2010, 01:43 PM posted to microsoft.public.access.gettingstarted
bezzauk
external usenet poster
 
Posts: 2
Default Linking a subform to current record

Hi.. Please can someone give me some help.

I have a form named 'Drawings'
I have a subform in this form called 'Revision Details'

I want to link the 2 forms so that the revision details for the current
record are shown.
So when I change to the next record the revision details for that record
should appear.
At the moment the revision details subform stays filled out with the same
data no matter what record I am viewing.

Is there a way to link it so that the revision details subform shows data for
the current record?

Many thanks for your help,

Bez

  #2  
Old May 4th, 2010, 02:57 PM posted to microsoft.public.access.gettingstarted
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Linking a subform to current record

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

  #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.


  #4  
Old May 4th, 2010, 11:18 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Linking a subform to current record

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

  #5  
Old May 5th, 2010, 08:52 AM posted to microsoft.public.access.gettingstarted
bezzauk via AccessMonster.com
external usenet poster
 
Posts: 2
Default Linking a subform to current record

Thank you,

I have managed to find and do the below. But now the Drawing Number field in
the revision subform displays #Name?
Which makes me think it cant find what it is looking for!!

Confused!!

Cheers

KenSheridan wrote:
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

Thank you,

[quoted text clipped - 18 lines]
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

  #6  
Old May 5th, 2010, 01:46 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Linking a subform to current record

What is the ControlSource property of the Drawing Number control in the
subform?

Ken Sheridan
Stafford, England

bezzauk wrote:
Thank you,

I have managed to find and do the below. But now the Drawing Number field in
the revision subform displays #Name?
Which makes me think it cant find what it is looking for!!

Confused!!

Cheers

Bez:

[quoted text clipped - 13 lines]
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

  #7  
Old May 6th, 2010, 11:39 AM posted to microsoft.public.access.gettingstarted
bezzauk via AccessMonster.com
external usenet poster
 
Posts: 2
Default Linking a subform to current record

Thank you, I think its working now.

Your prompted me to look at the control source property for the subform. This
was pointing to the revision details form, rather than the revision details
table. I changed it to the table and it now appears to work ok.

Many thanks

KenSheridan wrote:
What is the ControlSource property of the Drawing Number control in the
subform?

Ken Sheridan
Stafford, England

Thank you,

[quoted text clipped - 11 lines]
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.