Form Subform Data Input problems

[Stan Denman]

I have a form with a subform linked with the client's ID number. The subform is for the client address. When I view and scroll through records in the main form, I see the subform record move to the correct address for the client. But I have a number clients for whom I have not entered an address. when I try to do so in the subform I get this error:

"the Link Masterfields property setting produced this error: 'the object doesn't contain the Automation object 'tblCont'. The latter is a basis for the main form where the main form source is the following SQL:

SELECT tblCont.*, tblClients.*, [FirstName] & " " & [LastName] AS Name, tblCont.ContTypeID FROM tblCont INNER JOIN tblClients ON tblCont.ContID = tblClients.ContID
WHERE (((tblCont.ContTypeID)=1));



the subform source is:
SELECT trelContAddr.*, tblAddr.*
FROM tblAddr INNER JOIN trelContAddr ON tblAddr.AddrID = trelContAddr.AddrID;

I'm really stumped.

[June7]

Why are the RecordSources using INNER JOIN queries?

If you want to provide db for analysis, follow instructions at bottom of my post.