Error message in subform

T

Tony Williams

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
 
J

Jeanette Cunningham

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top