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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|