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.

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.

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.

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

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

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.

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.

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

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

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.