Error message in subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Williams - 13 Dec 2007 18:10 GMT

This is part of a previous post which I'd like to start a new thread as I
fixed half of the problem in the first.
I have a form that has a subform, subform1. The subform1 is based on a qry
which is based on two tables tblbusiness and tblindividual. On subform1 is a
tabcontrol and on one of the tabs is another subform based on a table called
tblidcards. I have linked the tabcontrol subform in datasheet format to the
subform1 on the primary key, called ID, of the table tblindividual. However
when I try to input anything into the subform on the tabcontrol I get an
error message

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

Can anyone help me with this problem?
Thanks
Tony

Reply to this Message

Jeanette Cunningham - 15 Dec 2007 02:04 GMT

Hi Tony,

If you copy the SQL of the query that is the recordsource for subform1 and
paste it into a reply for the newsgroup, it would help us to see why access
is giving this error.

To copy the SQL, open the query in design view
On the View menu dropdown, choose SQL view.
Copy the SQL view of the query.

Jeanette Cunningham

> This is part of a previous post which I'd like to start a new thread as I
> fixed half of the problem in the first.
[quoted text clipped - 12 lines]
> Thanks
> Tony

Reply to this Message