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
|
|||
|
|||
Can't find Master Link and Child Link Attributes
I have a form with 4 tabpages. I have subforms on two of those tabpages. I
successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
#2
|
|||
|
|||
In form design view, doulble click on the subform, the subforms properties
should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico "Laurel" wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
#3
|
|||
|
|||
When I do that I get the same thing I got when I right-moused on that area.
That is, I get the attributes of the underlying form. The Data tab contains things like "RecordSource", "Filter".....down to "Record Locks." No "Link" attributes. "rico" wrote in message ... In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico "Laurel" wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
#4
|
|||
|
|||
rico wrote:
In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. That is incorrect. The MasterLink and ChildLink properties are NOT properties of the form shown within the subform control. They are properties of the subform control itself. If you "single" click on the subform control then those properties should be shown on the {data} page of the property sheet. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Laurel wrote:
I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS[snip] You likely have your subform controls named the same as the forms within them (which is typical). What you see in the list are the controls as the forms within the subform controls are never shown in that list. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#6
|
|||
|
|||
single click.
the 1st time you click, you get the subform object the 2nd time you click, you get the form which is the 'sourceobject' of the subform. got it? "Laurel" wrote in message ... When I do that I get the same thing I got when I right-moused on that area. That is, I get the attributes of the underlying form. The Data tab contains things like "RecordSource", "Filter".....down to "Record Locks." No "Link" attributes. "rico" wrote in message ... In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico "Laurel" wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
#7
|
|||
|
|||
A single click just seems to select the subform (put 8 tiny squares on
corners and sides). This is what I would expect it to do. When I click after it is selected, it unselects (again, what I would expect). So, no, don't got it yet. I'm running Access 2000. Do you think there might be a bug involved here somewhere? "Malcolm Cook" wrote in message ... single click. the 1st time you click, you get the subform object the 2nd time you click, you get the form which is the 'sourceobject' of the subform. got it? "Laurel" wrote in message ... When I do that I get the same thing I got when I right-moused on that area. That is, I get the attributes of the underlying form. The Data tab contains things like "RecordSource", "Filter".....down to "Record Locks." No "Link" attributes. "rico" wrote in message ... In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico "Laurel" wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
#8
|
|||
|
|||
See reply to Malcom. Single click just selects the object. Isn't that what
it always does? I've also tried "single click/right mouse" No help there. "Rick Brandt" wrote in message ... rico wrote: In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. That is incorrect. The MasterLink and ChildLink properties are NOT properties of the form shown within the subform control. They are properties of the subform control itself. If you "single" click on the subform control then those properties should be shown on the {data} page of the property sheet. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#9
|
|||
|
|||
No, I don't have them named the same. I read a really excellent article
yesterday by Roger Carlson about why subforms can be confusing. Once I bumped into this problem, I carefully named the pages objects ContactPage and FundPage and left the forms with the Access default names, frmContacts and frmFunds. I've looked carefully at the list of objects in the menu dropdown. There simply aren't any third objects associated with the two tabpages that each have a sub-form on them. Again, I'm beginning to suspect some corruption here. Do you think it's time to start over? I will wait til I get a response to this notion that single-clicking on anything will bring up properties instead of selecting the thing. There's some missing info or bad communication going on here somewhere. Thanks for taking time with this! "Rick Brandt" wrote in message ... Laurel wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS[snip] You likely have your subform controls named the same as the forms within them (which is typical). What you see in the list are the controls as the forms within the subform controls are never shown in that list. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#10
|
|||
|
|||
after the single clicke, choose "View Properties" - then in the properites
window look at the 'Data' tab. Your memory should be refreshed.... "Laurel" wrote in message ... A single click just seems to select the subform (put 8 tiny squares on corners and sides). This is what I would expect it to do. When I click after it is selected, it unselects (again, what I would expect). So, no, don't got it yet. I'm running Access 2000. Do you think there might be a bug involved here somewhere? "Malcolm Cook" wrote in message ... single click. the 1st time you click, you get the subform object the 2nd time you click, you get the form which is the 'sourceobject' of the subform. got it? "Laurel" wrote in message ... When I do that I get the same thing I got when I right-moused on that area. That is, I get the attributes of the underlying form. The Data tab contains things like "RecordSource", "Filter".....down to "Record Locks." No "Link" attributes. "rico" wrote in message ... In form design view, doulble click on the subform, the subforms properties should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico "Laurel" wrote: I have a form with 4 tabpages. I have subforms on two of those tabpages. I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
link 2 Child fields to 2 Master fields. | Pradeep | Using Forms | 1 | January 24th, 2005 06:02 AM |
Redefine Index?? | Jeff C | General Discussion | 29 | January 20th, 2005 08:01 PM |
Link Child and Master Fields | Pradeep | Using Forms | 1 | January 19th, 2005 10:24 AM |
link master field/form to sub-form relationship | Luke | Using Forms | 1 | December 22nd, 2004 07:58 AM |
Link Master and Child Fields | bdehning | General Discussion | 0 | August 3rd, 2004 07:37 PM |