Michael Noze
asked on
This recordset is not updateable issue
Hi Experts,
I'm having an issue with a recordset.
In my query "qryInspection", I can't seem to check or uncheck the checkboxes.
It says: "This recordset is not updateable."
I didn't set any relationship, so I'm not sure why it's doing this.
Is there a solution to this?
I'm having an issue with a recordset.
In my query "qryInspection", I can't seem to check or uncheck the checkboxes.
It says: "This recordset is not updateable."
I didn't set any relationship, so I'm not sure why it's doing this.
Is there a solution to this?
Looking at your query, I notice that neither of your tables have a primary key defined, and there is no join between the two tables.
I would recommend working with your table design, and normalization first, before starting queries.
I would recommend working with your table design, and normalization first, before starting queries.
Please embed images in your post using the image button. This makes reading of your post simpler as there is no need to switch tabs in the browser. Edit your post.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Pat, you were spot on, it worked perfectly.
You're welcome. Sometimes it just takes fresh eyes and mine are as "fresh" as it gets :)
If you want to check the checkboxes....remove the Aggregation (Group By/Expression) and you will see it will work
If you want to check the checkboxes while keeping the query you need to work the base table (tblEquipment) do the checking and then work with the query.