Subform Linking Problem

[tbl]

Somewhere along the way, I managed to bugger a subform link.

Now, as soon as I try to enter a subform record, this pops
up:

*****
The LinkMasterFields property setting has produced this
error: "The object doesn't contain the Automation object
'tblIv."
*****

I've gone thru these forms a dozen times, and everything
seems right (including the child-master linking), but they
still don't work right.

It seems that records are being made in the subform's table,
except that the foreign key for the main table record is not
present, and on redisplaying the forms, the subform records
don't show.

Any advice?

 

[Ken Snell \(MVP\)]

Post the value of the LinkMasterFields property -- it would appear that the
field has been deleted and all that is left is the table reference?

 

[Steve Schapel]

Tbl,

Well, what have you got entered for the Link Master Fields and Link
Child Fields properties of the subform?

 

[tbl]

Post the value of the LinkMasterFields property --

LinkMasterFields property value: tblIv.IvId
LinkChildFields property value: IvId

it would appear that the
field has been deleted and all that is left is the table reference?

Hmmm. I *have* converted the source from just the table to
a query that provides everything from that table and
something from another table, but I thought that would be
transparent from the form's view.

Do I need to replace the table reference with a query
reference in the linkage between the two forms?

 

[tbl]

On Wed, 27 Dec 2006 07:33:21 +1300, Steve Schapel

Thanks for the reply, Steve.

Tbl,

Well, what have you got entered for the Link Master Fields and Link
Child Fields properties of the subform?

LinkMasterFields property value: tblIv.IvId
LinkChildFields property value: IvId


The main form's query seems to be pushing out proper values
for tblIv.IvId, so I'm a little stuck about where the
problem lies.

 

[Steve Schapel]

Tbl,

Change the Link Master Fileds property setting to simply:
IvId

 

[Rick Brandt]

On Wed, 27 Dec 2006 07:33:21 +1300, Steve Schapel

Thanks for the reply, Steve.



LinkMasterFields property value: tblIv.IvId
LinkChildFields property value: IvId


The main form's query seems to be pushing out proper values
for tblIv.IvId, so I'm a little stuck about where the
problem lies.

Press the builder button next to either property and choose the fields from the
lists provided.

 

[tbl]

Tbl,

Change the Link Master Fileds property setting to simply:
IvId

Yeah, that was one of the many things I've tried...

When I do that, and then open the form, I immediately get a
dialog asking for the parameter value for IvId.

And trying to make that setting in the build box for the
links, I'm told that it's "not an item in the list".

When I converted the main form's source from the table to a
query, I added a "join table" that has a field with the same
name/source (IvId), so I suppose the table name is needed to
keep everone straight...

 

[Rick Brandt]

Yeah, that was one of the many things I've tried...

When I do that, and then open the form, I immediately get a
dialog asking for the parameter value for IvId.

And trying to make that setting in the build box for the
links, I'm told that it's "not an item in the list".

That would indicate that no field with that name exists in the query. If you
display the field list while in design view of the main form do you see a field
with that name?

 

[tbl]

That would indicate that no field with that name exists in the query.

But... but... it *does* exist! And the query outputs it
fine.

If you display the field list while in design view of the main form
do you see a field with that name?

Hmmm. Didn't try that, and I still don't understand the
problem... but... I *did* realize that the join table I'd
brought into the query was unnecessary, and when I removed
it, and just used the raw table for the form's source,
again, the problem vanished.

I seem to be in the realm of possible progress again. As
much as I would really like to understand why I couldn't get
that to work with the join table in the frey, I'm way behind
on "actual" progress, and just can't justify spinning
further on it.

Thanks for all your time. It was your questions that helped
me realize my join table wasn't being used.

 

[tbl]

Press the builder button next to either property and choose the fields from the
lists provided.

Thanks, Rick

If I use the builder, it only lists tblIv.IvId. If I use
brute force and type in IvId, it nullifies my brute force,
telling me that it's "not an item on the list".

But I've made a structural change to the form, and booted
out a join table from the main form's source query, and the
problem has vaporized.

Thanks for the hints--now I'm racing off toward the next
brick wall, whatever that may be!