Non Updatable Query?

[RDM]

Hi, I'm using a query that won't let me update data when viewed either in query mode, or through a subform.

All other queries in my database are updatable, however, this query i have now contains several sections like this

[SUBURB] Like "*" & [Forms]![FormFINDER]![SUBURB] & "*" Or [Forms]![FormFINDER]![SUBURB] Is Null

group by expression
show is unchecked
criteria is true

will having something like this in a query prevent it from being updatable?
or is there another issue causing the problem?

 

[boblarson]

A grouped by query will always be non-updateable. How would Access know which record needs to be updated?

See here for more on non-updateable queries:
http://allenbrowne.com/ser-61.html

 

[RDM]

thanks for the prompt reply bob.

if i wanted to have a query search form, then display the results in a datasheet subform.. how would i make the query updatable?