My application is based on a tblContact, which contains detailed info for each client in our database. An associated form, frmContact, uses this table for most of its fields, the top of the form is general info and there are 5 tabs for specific info.
I'm adding a new tab which needs to use data in a new table, tblContactTCP. These 2 tables are connected with a INNER JOIN via the fields tblContact.ContactID and tblContactTCP.TContactID.
SELECT tblContact.*, tblContact.ContactID, tblContactTCP.*
FROM tblContact INNER JOIN tblContactTCP ON tblContact.ContactID = tblContactTCP.TContactID
The app also has a form showing a list of all these Contacts filtered by type. When I go to the list and select the contact I'm interested in and click on the detail button, the first form mentioned opens on the screen. The code used to open the form is:
DoCmd.OpenForm "frmContact", , , "ContactID = " & Me.frmSub.Form.ContactID, , , "Type = " & Me.cboType
However, after adding the new tab and try to get to the first form I get the error 3079, whether I try the INNER JOIN as the form's RecordSource or just reference the second table via subforms in the new tab I get the error:
Run-time error 3079
The specified fied'ContactID' could refer to more that one table listed in the FROM clause
of your SQL statement.
What am I missing??