Solved group option issue

[TipsyWolf]

hello guys!

i have tables and relationship

i have a continuous form where i put group option so a user could input data (response to some question)

i have sql of its form

SELECT
    Employees.EmployeeID,
    Employees.TrainingID,
    Employees.FullName,
    Employees.JobTitle,
    Q1.Response AS ResponseToQuestion1,
    Q2.Response AS ResponseToQuestion2
FROM
    (Employees
    LEFT JOIN
        (SELECT EmployeeID, Response FROM Responses WHERE QuestionID = 1) AS Q1
        ON Employees.EmployeeID = Q1.EmployeeID)
    LEFT JOIN
        (SELECT EmployeeID, Response FROM Responses WHERE QuestionID = 2) AS Q2
        ON Employees.EmployeeID = Q2.EmployeeID;

and two group options with
control source ResponseToQuestion1 and ResponseToQuestion2
and name optQuestion1 and optQuestion2

additionally showing u my Question table

it says recordset is not updatable. whats the issue here ?
please help me .. already spent like 10 hours and find the solution

upd: attaching db file

 

[jdraw]

see this from Allen Browne http://allenbrowne.com/ser-61.html

 

[TipsyWolf]

see this from Allen Browne http://allenbrowne.com/ser-61.html

i just changed the recordset type from Dynaset to Dynaset (Inconsistent Updates) and it worked !!!!!!!!!!!!!! thank you very much !)!)
your link helped