Added table to database, added to form, now cannot update

All worked fine until we added this table to form. Now cannot even delete
table and get form to work correctly.

Here is SQL statement from form's record source:

SELECT tblSalary.*, tblEmployee.*, tblSalary.PayRatioMemo,
qselFullName.[Full Name], qselFullName.SocialSecurity, tblSalary.[Benefit
Notation], tblHRInsurance.InsurancePercent, tblHRInsurance.InsDesc
FROM tblTimeOff INNER JOIN (((tblEmployee INNER JOIN qselFullName ON
tblEmployee.SocialSecurity = qselFullName.SocialSecurity) INNER JOIN
tblHRInsurance ON tblEmployee.SocialSecurity = tblHRInsurance.EmployeeId)
INNER JOIN tblSalary ON tblEmployee.SocialSecurity = tblSalary.EmployeeID) ON
tblTimeOff.TimeOffID = tblSalary.TimeOffID;

Let me know if more information is needed.

It is...

"dhoeft" wrote in message
...
All worked fine until we added this table to form. Now cannot even delete
table and get form to work correctly.

Here is SQL statement from form's record source:

SELECT tblSalary.*, tblEmployee.*, tblSalary.PayRatioMemo,
qselFullName.[Full Name], qselFullName.SocialSecurity, tblSalary.[Benefit
Notation], tblHRInsurance.InsurancePercent, tblHRInsurance.InsDesc
FROM tblTimeOff INNER JOIN (((tblEmployee INNER JOIN qselFullName ON
tblEmployee.SocialSecurity = qselFullName.SocialSecurity) INNER JOIN
tblHRInsurance ON tblEmployee.SocialSecurity = tblHRInsurance.EmployeeId)
INNER JOIN tblSalary ON tblEmployee.SocialSecurity = tblSalary.EmployeeID)
ON
tblTimeOff.TimeOffID = tblSalary.TimeOffID;

Let me know if more information is needed.