Recordset not Updateable in Query

[KKilfoil]

I have a select query that includes two related Record Sources; a table, and a query based on that same table that includes an aggregate function (count).

As soon as I included the query, my recordset became non-updateable. (Yes, I know that's what supposed to happen!)

Hoping to find a workaround, I searched this forum and came across this statement from Pat Hartman:

"Queries that include aggregate functions such as Max() are NOT updateable. You need to rework the query so that the Max() value is retrieved via a sub-select. That will probably fix the problem."

What did she mean by a 'sub-select'? and how do I use it?

 

[KKilfoil]

Thank you for your reply.

I think I understand what you are saying.

In my case, I was trying to count the number of records matching several criteria on the 'many' side of a 1:M relationship, and show this count on the same form used by the user for record entry/modification of the '1'-side table.

To get around the 'recordset not updatable' problem, I wrote a vba function to return the appropriate count from a summary query instead.