Query not updatable
-
- 2StarLounger
- Posts: 125
- Joined: 17 Feb 2010, 16:25
Query not updatable
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)
Lost Wages, NV USA
(former Cobol Programmer)
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Query not updatable
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.
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'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
Hans
-
- 2StarLounger
- Posts: 125
- Joined: 17 Feb 2010, 16:25
Re: Query not updatable
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--
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)
Lost Wages, NV USA
(former Cobol Programmer)