I have linked the table and created the query. Here is the SQL in case that will help. Also, I linked the table to the back end portion of the database - Is that an issue?
I have a button that is used to enter the user id of the auditor and the data audited - when I push it I get the error "This Recordset is not updateable".
I also have a text box for audit comments - It does not allow me to type in it.
Code:
SELECT tblAutoAudits.AuditName, tblAutoAudits.Unit, tblAutoAudits.Manager, tblAutoAudits.UserName, tblAutoAudits.[Claim Number], tblAutoAudits.LossDate, tblAutoAudits.[Date Audit Pulled], tblAutoAudits.[Loss Description], tblAutoAudits.COL, tblAutoAudits.Auditor, tblAutoAudits.DateAudited, tblAutoAudits.Coverage, tblAutoAudits.[Investigation/ Liability], tblAutoAudits.Financials, tblAutoAudits.APD, tblAutoAudits.[Injury Evaluation & Settlement], tblAutoAudits.[Documentation/ File Coding], tblAutoAudits.[Communication & Customer Service], tblAutoAudits.[Audit Comments], tblAutoAudits.[Positive Feedback], tblAutoAudits.[Opportunity for Improvement], tblAutoAudits.[Overall Score], tblAutoAudits.[Skip Reason], tblAutoAudits.Area, tbl_Directors.[Director Name], Rnd([Overall Score]) AS Random, tblAutoAudits.ReauditedBy, tblAutoAudits.DateReaudited, tblAutoAudits.ReAuditFeedback
FROM tblAutoAudits INNER JOIN tbl_Directors ON tblAutoAudits.Area = tbl_Directors.Area
WHERE (((tblAutoAudits.[Overall Score]) Is Not Null));