Can't find Master Link and Child Link Attributes

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

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.
 
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
 
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 said:
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.
Click to expand...

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.
 
Laurel said:
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]
Click to expand...

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.
 
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?
 
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?
 
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.
 
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 said:
Laurel said:
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]
Click to expand...

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.
Click to expand...
 
after the single clicke, choose "View > Properties" - then in the properites
window look at the 'Data' tab. Your memory should be refreshed....
 
Laurel said:
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.
Click to expand...

Yes and when you single click what do you see in the property sheet?
 
BINGO!!!!!!!!
THANKS!!!!!

I really don't think this is how I did it for the first tab - menu didn't
feel familiar, but who cares!
 
Rick Brandt said:
Yes and when you single click what do you see in the property sheet?
Click to expand...

If I went to the property sheet the way I usually do, right
mouse/properties, I see the data properties of he underlying form BUT!!!!
If I use the View menu at the top and choose properties as suggested by
Malcom, above, I get what. YAY!!!!
I guess what I did to set the first one will forever be a mystery.
 
Single-clicking does not bring up properties (unless the Properties are
already displayed for another control). Once a control is selected, you can
then bring up the properties by going to View Properties, pressing F4,
clicking the Properties button on the Toolbar, OR right-clicking on the
control selected and choosing Properties.

In my answer to your previous post, I assumed that you knew how to display
the Properties.

Debbie


| 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!
|
| | > 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
 
I think I do know how to display properties. I just didn't know that in the
case of a subform, the way that I usually use (rightmouse/properties) didn't
work.

DebbieG said:
Single-clicking does not bring up properties (unless the Properties are
already displayed for another control). Once a control is selected, you can
then bring up the properties by going to View Properties, pressing F4,
clicking the Properties button on the Toolbar, OR right-clicking on the
control selected and choosing Properties.

In my answer to your previous post, I assumed that you knew how to display
the Properties.

Debbie


| 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!
|
| | > 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
Click to expand...
 
I have no problem using the right-mouse to display the properties for a
subform control. I still don't understand why you're having problems with
that.


|I think I do know how to display properties. I just didn't know that in
the
| case of a subform, the way that I usually use (rightmouse/properties)
didn't
| work.
|
| | > Single-clicking does not bring up properties (unless the Properties are
| > already displayed for another control). Once a control is selected, you
| can
| > then bring up the properties by going to View Properties, pressing F4,
| > clicking the Properties button on the Toolbar, OR right-clicking on the
| > control selected and choosing Properties.
| >
| > In my answer to your previous post, I assumed that you knew how to
display
| > the Properties.
| >
| > Debbie
| >
| >
| > | > | 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!
| > |
| > | | > | > 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
| >
|
|
 
Me either. As I mentioned a couple of times, I suspect some subtle
corruption of the db. Like.. why would the PASTE menu item, alone of al
lthe others, be disabled. Weird. But, thankfully, I have a solution.
Thanks for pointing out that what I thought might be standard behavior is
actually still "weird."

DebbieG said:
I have no problem using the right-mouse to display the properties for a
subform control. I still don't understand why you're having problems with
that.


|I think I do know how to display properties. I just didn't know that in
the
| case of a subform, the way that I usually use (rightmouse/properties)
didn't
| work.
|
| | > Single-clicking does not bring up properties (unless the Properties are
| > already displayed for another control). Once a control is selected, you
| can
| > then bring up the properties by going to View Properties, pressing F4,
| > clicking the Properties button on the Toolbar, OR right-clicking on the
| > control selected and choosing Properties.
| >
| > In my answer to your previous post, I assumed that you knew how to
display
| > the Properties.
| >
| > Debbie
| >
| >
| > | > | 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!
| > |
| > | | > | > 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
| >
|
|
Click to expand...
 
You seem to have some confusion between your tab pages and your
subform controls and your forms?

pages should be called page
subform controls should be called sbfxxxxxx
forms should be called .....

From your description, it appears that in the list of controls
you can see your page controls and your subform controls. The
subform controls have the same names as the subforms.

BTW, if you open the subform in design view FIRST, then open
the main form in design view, you don't get the subform stuck
inside the subform control.

(david)


Laurel said:
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 said:
Laurel said:
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]
Click to expand...

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.
Click to expand...
Click to expand...
 
You seem to have some confusion between your tab pages and your
subform controls and your forms?
Click to expand...

No, I don't think so. Perhaps you didn't notice my explanation embedded in
the
thread. It seems that my system is behaving differently than it should.
I've found a work-around by using the menu at the top to get at the
properties wndow for he control.


david epsom dot com dot au said:
You seem to have some confusion between your tab pages and your
subform controls and your forms?

pages should be called page
subform controls should be called sbfxxxxxx
forms should be called .....

From your description, it appears that in the list of controls
you can see your page controls and your subform controls. The
subform controls have the same names as the subforms.

BTW, if you open the subform in design view FIRST, then open
the main form in design view, you don't get the subform stuck
inside the subform control.

(david)


Laurel said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
I don't think so. Perhaps you didn't notice my explanation

I read that, and it doesn't support your argument:

You mention renaming the page objects and not
finding third objects.

Perhaps you meant that you had renamed the subform
controls and could not find the page objects?

I'm glad that you have found the subform control
properties, and I'm certain that eventually you
will sort out the nomenclature :)

BTW, subforms are quite slow. I never have a default
subform in a tabbed page unless the page is visible.
I load the subform in the subform control only when
the page becomes visible. Actually, in many places
I place a single subform control /below/ the tabbed
pages, and load a different form into the control
for each page. It's a bit fiddly to get the layout
correct for a single subform control beneath a tab
control, but it does look ok after some effort.

(david)



Laurel said:
You seem to have some confusion between your tab pages and your
subform controls and your forms?
Click to expand...

No, I don't think so. Perhaps you didn't notice my explanation embedded
in
the
thread. It seems that my system is behaving differently than it should.
I've found a work-around by using the menu at the top to get at the
properties wndow for he control.


david epsom dot com dot au said:
You seem to have some confusion between your tab pages and your
subform controls and your forms?

pages should be called page
subform controls should be called sbfxxxxxx
forms should be called .....

From your description, it appears that in the list of controls
you can see your page controls and your subform controls. The
subform controls have the same names as the subforms.

BTW, if you open the subform in design view FIRST, then open
the main form in design view, you don't get the subform stuck
inside the subform control.

(david)


Laurel said:
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!

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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top