Error with subform

[Guest]

What does the following mean? I am working on a subform to a form and get the following:

The LinkMasterfields property Setting has produced this error; "The Object doesn't contain the automation object 'Account Information'.

 

[Ken Snell]

It means there is no field in the main form's record source named "account
information" and there is no control on the main form named "account
information".

--

Ken Snell
<MS ACCESS MVP>

What does the following mean? I am working on a subform to a form and get the following:

The LinkMasterfields property Setting has produced this error; "The Object

doesn't contain the automation object 'Account Information'.

 

[Guest]

Ken,

If I take out Account Information.policy number in the Link Master Fields and just put policy number I get The specified field '[Policy Number]' could refer to more than
one table listed in the From Clause of yur SQL statement.

This subform is connected to a form that uses all connected tables and fields from all tables.

There would not be a field Account Information as that is the main table name.

Any more help you can provide.

 

[Ken Snell]

Try this in the Link Master Fields :

[Account Information.Policy Number]

--

Ken Snell
<MS ACCESS MVP>

Ken,

If I take out Account Information.policy number in the Link Master Fields

and just put policy number I get The specified field '[Policy Number]' could
refer to more than

 

[Guest]

Ken,

Thank You, That did the trick!

Is the child field important for linking as well?
--
Brian

Try this in the Link Master Fields :

[Account Information.Policy Number]

--

Ken Snell
<MS ACCESS MVP>

Ken,

If I take out Account Information.policy number in the Link Master Fields

and just put policy number I get The specified field '[Policy Number]' could
refer to more than

 

[Ken Snell]

Important? without it, there is no link between your main form and your
subform, so, yeah, I'd say it's important.

--

Ken Snell
<MS ACCESS MVP>

Ken,

Thank You, That did the trick!

Is the child field important for linking as well?
--
Brian

Try this in the Link Master Fields :

[Account Information.Policy Number]

--

Ken Snell
<MS ACCESS MVP>

Ken,

If I take out Account Information.policy number in the Link Master

Fields
and just put policy number I get The specified field '[Policy Number]' could
refer to more than

one table listed in the From Clause of yur SQL statement.

This subform is connected to a form that uses all connected tables and fields from all tables.

There would not be a field Account Information as that is the main

table
name.

Any more help you can provide.

--
Brian


:

It means there is no field in the main form's record source named "account
information" and there is no control on the main form named "account
information".

--

Ken Snell
<MS ACCESS MVP>

What does the following mean? I am working on a subform to a form

and
get

the following:

The LinkMasterfields property Setting has produced this error;

"The
Object

doesn't contain the automation object 'Account Information'.

 

[Guest]

The reason I ask is that if I place [Account Information.Policy Number] in child link field I get the error again. If I only place it in Master Field link it works.

I did post another question as well concerning trying to use the subform by itself and how one might do that. Question in general access.

Thanks for your help.
--
Brian

Important? without it, there is no link between your main form and your
subform, so, yeah, I'd say it's important.

--

Ken Snell
<MS ACCESS MVP>

Ken,

Thank You, That did the trick!

Is the child field important for linking as well?
--
Brian

Try this in the Link Master Fields :

[Account Information.Policy Number]

--

Ken Snell
<MS ACCESS MVP>

Ken,

If I take out Account Information.policy number in the Link Master Fields
and just put policy number I get The specified field '[Policy Number]' could
refer to more than
one table listed in the From Clause of yur SQL statement.

This subform is connected to a form that uses all connected tables and
fields from all tables.

There would not be a field Account Information as that is the main table
name.

Any more help you can provide.

--
Brian


:

It means there is no field in the main form's record source named
"account
information" and there is no control on the main form named "account
information".

--

Ken Snell
<MS ACCESS MVP>

What does the following mean? I am working on a subform to a form and
get
the following:

The LinkMasterfields property Setting has produced this error; "The
Object
doesn't contain the automation object 'Account Information'.

 

[Ken Snell]

The Link Child Fields should contain the name of the field in the subform's
recordsource that is "linked" (joined) to the [Account Information.Policy
Number]. If you have such a field already in the subform, ACCESS often will
"find" it and assume that that is the link.

I don't know enough about your setup to comment further, but just having a
Master link and no Child link, in my expectation, will not correctly link
the main form and the sub form.

--

Ken Snell
<MS ACCESS MVP>

The reason I ask is that if I place [Account Information.Policy Number] in

child link field I get the error again. If I only place it in Master Field
link it works.

I did post another question as well concerning trying to use the subform

by itself and how one might do that. Question in general access.

Thanks for your help.
--
Brian

Important? without it, there is no link between your main form and your
subform, so, yeah, I'd say it's important.

--

Ken Snell
<MS ACCESS MVP>

Ken,

Thank You, That did the trick!

Is the child field important for linking as well?
--
Brian


:

Try this in the Link Master Fields :

[Account Information.Policy Number]

--

Ken Snell
<MS ACCESS MVP>

Ken,

If I take out Account Information.policy number in the Link Master Fields
and just put policy number I get The specified field '[Policy

Number]'
could

refer to more than
one table listed in the From Clause of yur SQL statement.

This subform is connected to a form that uses all connected tables and
fields from all tables.

There would not be a field Account Information as that is the main table
name.

Any more help you can provide.

--
Brian


:

It means there is no field in the main form's record source named
"account
information" and there is no control on the main form named "account
information".

--

Ken Snell
<MS ACCESS MVP>

What does the following mean? I am working on a subform to a

form
and

get
the following:

The LinkMasterfields property Setting has produced this error; "The
Object
doesn't contain the automation object 'Account Information'.