Query not updatable

PaulW
2StarLounger
Posts: 125
Joined: 17 Feb 2010, 16:25

Query not updatable

Post by PaulW »

I have a continuous form whose recordsource is a query that joins 3 summary queries and a fourth table. I am unable to modify/update/delete the records in the table. I get the messages in the attached screen shots. What am I doing wrong?
You do not have the required permissions to view the files attached to this post.
PaulW
Lost Wages, NV USA
(former Cobol Programmer)

User avatar
HansV
Administrator
Posts: 78241
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Query not updatable

Post by HansV »

If by "summary queries" you mean totals queries (i.e. queries for which the Totals button in the ribbon is "on"), that's to be expected: queries based on a totals query are never updateable, nor are forms based upon such queries.
x103.png
You'll have to base the form on the table, and use other means to display the summary information, for example expressions involving DCount, DSum etc., or a subform.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

PaulW
2StarLounger
Posts: 125
Joined: 17 Feb 2010, 16:25

Re: Query not updatable

Post by PaulW »

Hans,

Thanks for the explanation. I decided to use "public variables" for the four fields that came from the totals records and just use the table for the continuous form. --Learning All The Time--
PaulW
Lost Wages, NV USA
(former Cobol Programmer)