using a Group by Query and getting 'recordset not updatable'. help!

[ruthcali]

i am using Acces97.

i would like help with the 'recordset not updatable' message.

i have a query that uses Group by. i think that is the problem.

here is the SQL of my query:

SELECT OPCNumber, Count(OPCNumber) AS [Num], ChkOK
FROM tblOPCInfo
WHERE [NE#] Is Not Null
GROUP BY OPCNumber, ChkOK
HAVING (((Count(OPCNumber))>14) AND ((ChkOK)=False))
ORDER BY OPCNumber;

I have a form based on this query that alerts the user when OPCNumber>14. The user only needs to see this data once. He doesn't need to see all the records where the OPCNumber>14 every time he opens the form. So i made a check box with the title: "OK, Don't show again".

So if he clicks on the check box, next time he opens the form, that particular record won't show up.

But, it doesn't work because when you try click on the ChkOK box, i get 'recordset not updatable'.

Does anyone know what i should do?

thanks,

 

[JUANCARLOS]

You cant update a Group By query, but if you have to add records or update the fields of the query I think you should have to do this:

With the same query you have, modify the type of query, from selection to creation table.

This query make a auxiliary table that you can reference in your form and can update it. any time you can needed, the query creation table, erase the oldest and create the newest, you can try. Also you can trap an mantain the record update it.

If you speak spanish, I explain wiht more details.